Forum Discussion
Solved
Format range when two conditions are met
I need to format a range when cell G4 matches
Price: G4 (dynamic)
Target1: H4 (static)
Target2: I4 (static)
Target3: J4 (static)
Highlight H4 when it equals G4 and is between I4
Highlight I4 when it equals G4 and is between J4
Highlight J4 and is less than equals G4
https://1drv.ms/x/s!Ai3wejactZJ_licmHMLM2tBCbH7G?e=xp55O8
It is not possible to create or edit rules of type "Use a formula to determine which cells to format" in Excel Online. You have to do so in the desktop version of Excel in Microsoft 365 (on Windows or Mac).
6 Replies
You need to create a separate rule for each of the cells H4, I4 and J4:
The formula in the rule for J4 is simpleL
=G4<=J4
That for I4 is
=AND(G4<=I4,G4>J4)
And for H4:
=AND(G4<=H4,G4>I4)
- I am having difficulty implementing your answer.
If you look at the sheet perhaps you may see where I am going wrong.
Thank youHere it is
