Highlight one cell based on date in a range
Solved/Closed
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.
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.
Related:
- Highlight one cell based on date in a range
- Instagram account based in wrong country - Instagram Forum
- Insert a function in cell b2 to display the current date from your system. ✓ - Excel Forum
- Insert a new sheet at the end of the tab names and paste the range names starting in cell a1. autofit columns a:b and name the worksheet as range names. ✓ - Excel Forum
- If a cell has text then return value ✓ - Excel Forum
- Highlight cell if another cell contains text - Excel Forum
1 response
=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.
