Highlight one cell based on date in a range

coldwind - Sep 23, 2009 at 04:50 PM
 coldwind - Sep 24, 2009 at 09:52 AM
Using conditional formatting I wanted to highlight one cell based on a range. I wanted for example a1 text to be highlighted when one cell or mutiple cells in c1:c10 date was going to expire or about to expire say <=today()+110. I already have the cells in the range c1:c10 to highlight if they are expired. But I am not able to make a1 highlight if c5 has an expired date. It only highlights when its c1.

1 reply

=COUNTIF($C$1:$C$10,"<"&(TODAY()+100)) If anyone had the same problem, I think I figured it out. This has been working when I select cell A1 and put this in the formula the text becomes highlighted when the date is passed and and going to be passed due. Now only if I can figure a macro code that will change the tab color because of an expired date.