SRMPURCHASE
Board Regular
- Joined
- Dec 23, 2014
- Messages
- 210
- Office Version
- 2016
- Platform
- Windows
The main intent is for J14 to change colors when:
A14:A200 = any value (10 choices) in the range $G$1:$G$10 and;
J14:J200 <= to any value (10 choices) in range $H$1:$H$10
I currently use the following formula repeated 10 times for each combination in G and H ranges.
FOR CELL J14 "AND($A14=$G$1,$J14<=$H$1)
Changing the G and H row references for each of the 10 CF formulas.
Is there a more efficient way to express this in a single formula?
A14:A200 = any value (10 choices) in the range $G$1:$G$10 and;
J14:J200 <= to any value (10 choices) in range $H$1:$H$10
I currently use the following formula repeated 10 times for each combination in G and H ranges.
FOR CELL J14 "AND($A14=$G$1,$J14<=$H$1)
Changing the G and H row references for each of the 10 CF formulas.
Is there a more efficient way to express this in a single formula?