Jun 28 2019 02:50 AM
Hi There,
I have what is probably a really obvious conditional formatting formula query. Basically, i want a row to turn yellow if the date in one row (J) is today or earlier, but I then want to override this and highlight the row in a different colour once another row (U) is populated with text ("complete" the row will turn grey, "cancelled" the row will turn red - if blank or "in progress" it remains yellow).
I have set up the formulas (so =$U8="cancelled" format red / =$U8="complete" format grey / =$J8<TODAY() format yellow), and also set up the rule preference with the date at the bottom.
The issue is, the U8 rules do take precedence and highlight the rows in the correct colour but with the exception of the date reference cell in J which stays yellow. I tried changing it to an AND formula (to apply if U8 is blank or has other content) but then it just stays white when cancelled or complete is applied.
I am sure this is so simple, but if anyone could point me in the right direction?
Trish
Jun 28 2019 08:11 AM
Jun 28 2019 10:55 AM - edited Jun 28 2019 11:00 AM
@Sergei Baklan Thank you, though that doesn't seem to work either.
Seemed perfect on your version though - i must be making an error with the formula somewhere.....
Jun 28 2019 01:27 PM
SolutionPlease check attached
Jun 28 2019 02:08 PM
@Sergei Baklan thank you so much, it was driving me mad - that seems to work perfectly. Not sure what i did, but really appreciate your help!
Jun 28 2019 01:27 PM
Solution