Thread: how can I highlight a cell if it meets year and month criteria
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Clyde
 
Posts: n/a
Default how can I highlight a cell if it meets year and month criteria
This is the formula that I have in the column:
=IF(K104=0,"",(DATE(YEAR(K104),MONTH(K104)+24,DAY( K104))))

If the month and year is reached I want the cell highlighted in red, if
exceeded I want the cell in yellow.

How do I do this?
Reply With QuoteReply With Quote