May 19 2021 06:58 PM
Hello,
Just wondering if someone can help me, I need to enter some conditional formatting into my spreadsheet and can't work out the formula.
What I would like is the row to turn red when the recall date in column E is reached. Then when a date is entered into column F I would like the row to turn yellow. And lastly when a date is entered into column I, I would like the row to turn green.
Could someone steer me in the right direction?
Thanks!
May 19 2021 09:06 PM
@jbutlerorth See attached file. I believe it has the CF rules you need.
May 19 2021 09:45 PM - edited May 19 2021 09:49 PM
Amazing! Thank you so much! My only problem is that on my actual spreadsheet the rows further down the list that haven't has anything entered yet are coming up red, any suggestions?