Forum Discussion
Change blank cell colour based on date in other cell
Hi, I'd appreciate any help with 3 conditional formatting issues I'm trying to work out please If the date in cell H has passed and there's a date (any date) in cell I then turn it green If the...
Hi Craigm88,
I have created a sample document and set your desired conditional formatting. Have fun with Excel.
Hi, thanks for the help, it does work based on the info I provided but I forgot that the data is pulled from a table on another sheet so all those blank cells actually contain "=Table1[@[Evidence Received Date]]" so they're technically not blank, because the source is empty it returns 00/01/1900 I just change the options so that anything with a 0 would return as blank