View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Udayan Udayan is offline
external usenet poster
 
Posts: 17
Default Quday001-Conditional Formatting

I have a column containing dates (A1:A100) in date format.
Colour of all the cells in that column (A1:A100) is yellow and I want to the
blank cells as it is.


Highilighted the required cells (A1:A100) and Given formula in condition
formatting
=AND(TODAY()-A1365,A10)

Is it possible to do the same in multiple column
ie., (A1:G100)