Highlight one cell based on date in a range
Solved/Closed
Related:
- Highlight one cell based on date in a range
- Folder highlight - Download - Customization
- Excel if range of cells contains specific text then return value ✓ - Excel Forum
- How to disable a cell in excel based on condition vba ✓ - Excel Forum
- Excel duplicate rows based on cell value ✓ - Excel Forum
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.