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 Highl...
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).
I am having difficulty implementing your answer.
If you look at the sheet perhaps you may see where I am going wrong.
Thank you
If you look at the sheet perhaps you may see where I am going wrong.
Thank you
Here it is
- Unfortunately I am using 365 and the Conditional Formatting screen is different to the Office desktop app
I am able to see what you were able to come up with but I am unable to make the change because the screen is different.
I have allowed my file to be edited. If you are able to edit my file that would be a big help.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).
- Okay, I understand, the online version has limited features.
Thank you