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
- Count if cell contains number - Excel Forum
- Excel macro to create new sheet based on value in cells - Guide
- If cell contains specific text then return value in another cell ✓ - Excel Forum
- Insert the current date and time in cell a1 ✓ - 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.