Highlight one cell based on date in a range Solved/Closed

Question

Hello,
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.

coldwind · Accepted Answer

=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.

Highlight one cell based on date in a range

1 response

Similar discussions

Subscribe To Our Newsletter!