Previous Topic Next Topic

Highlight one cell based on date in a range

Solved/Closed
coldwind - Sep 23, 2009 at 04:50 PM
 coldwind - Sep 24, 2009 at 09:52 AM
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.

1 reply

Answer 1 / 1
coldwind
Sep 24, 2009 at 09:52 AM
=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.
6

Similar discussions

Highlight cell if another cell contains any text
LvH -
LvH -

4 responses
help me to add particular cells
mathewmunna -
mathew munna -

2 responses
How do I change a base location on Instagram?
rebelkids -
38nancy -

8 responses
Ig stories from close friends to public
Darren -
Kara -

30 responses
Excel - IF function with multiple words
Nick -
user -

14 responses
Highlight cell if another cell contains specific text
Abbi -
vcoolio -

1 response