Conditional Formatting range of date cells based on another cell
Solved/Closed
cleaverr
Posts
3
Registration date
Monday December 12, 2016
Status
Member
Last seen
December 13, 2016
-
Dec 12, 2016 at 03:00 PM
cleaverr - Jan 5, 2017 at 06:18 AM
cleaverr - Jan 5, 2017 at 06:18 AM
Related:
- Conditional formatting based on date in another cell
- Excel conditional formatting if another cell contains specific text ✓ - Excel Forum
- Highlight cell if another cell contains specific text - Excel Forum
- Highlight cell if another cell contains any text ✓ - Excel Forum
- Based on the values in cells b77 b81 ✓ - Excel Forum
- Conditional formatting if another cell contains - Excel Forum
Dec 13, 2016 at 06:22 AM
many thanks
Dec 13, 2016 at 06:50 AM
"IF(DATEVALUE,$D$2:$O$2<DATEVALUE,B2)" and formatting this for green.
and the same formula with > to be red.
but it is not working.