Conditional formatting: change cell background colour when another cell's date = today [closed]
Hi all.
In the example provided I want to change the background colour of cells in the "GOAL" column (columns B through J) as well as cells in the DATE column (column A) to red when the date = today… how might I go about doing this…?
C:\fakepath\Date conditional formatting example.ods
Thanks very much.