J
Jock
With this CF in column "D", "Cell Value is less than =NOW()", the cell colour
becomes red if the date in "D" is less than today's date.
Column E may have text in it.
So using CF, "D" to go red if date is less than NOW() but if text in "E",
then remove red, i.e no formatting at all
Any ideas?
becomes red if the date in "D" is less than today's date.
Column E may have text in it.
So using CF, "D" to go red if date is less than NOW() but if text in "E",
then remove red, i.e no formatting at all
Any ideas?