Forum Discussion

Copper Contributor

Jun 28, 2019

Solved

Conditional Formatting Formula

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 ov...

excel

SergeiBaklan
Jun 28, 2019
trishmci

Please check attached
Event Brief Tracker (Draft).xlsx51 KB

SergeiBaklan

Diamond Contributor

Jun 28, 2019

trishmci

Hi Trish,

Perhaps like

with yellow rule

=($J8<=TODAY())*NOT(ISBLANK($J8))

CF date status.xlsx11 KB

trishmci

Copper Contributor

Jun 28, 2019

SergeiBaklan 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.....

Event Brief Tracker (Draft).xlsx57 KB

SergeiBaklan
Diamond Contributor
Jun 28, 2019
trishmci

Please check attached
Event Brief Tracker (Draft).xlsx51 KB
- trishmci
  Copper Contributor
  Jun 28, 2019
  SergeiBaklan thank you so much, it was driving me mad - that seems to work perfectly. Not sure what i did, but really appreciate your help!
  - SergeiBaklan
    Diamond Contributor
    Jun 28, 2019
    trishmci , you are welcome, glad to help