Quday-Conditional Formatting

  • Thread starter Thread starter Udayan
  • Start date Start date
U

Udayan

I have a column containing dates (A1:A100) in date format.
Colour of all the cells in that column (A1:A100) is yellow.

Highilighted the required cells (A1:A100) and Given formula in condition
formatting
=today()-A1>365

My problem is that the blank cells also showing RED colour.

I want to the blank cells as it is.

Kindly helpppppppppppppp meeeeeeeee
 
Appreciate your quick reply.

Thanks you are a Gentle Man

Thank you very much............. for your great help
 
It worked thanks,

If i want to do the same thing with a group of columns
for example (A1:F100)

will this same formula works
 
Back
Top