Related:
- Conditional Formatting in relation to date
- Excel date format dd.mm.yyyy - Guide
- How to clear formatting in excel - Guide
- How to change time format in whatsapp - Guide
- Excel formula to change cell color without conditional formatting - Excel Forum
- To change conditional formatting that applies a red fill color to one that applies a green fill color, which of the following can you do? - Excel Forum
1 response
Hi Mikey,
Start by selecting the cells of the column you want to color.
Activate conditional format.
Condition 1: Formula is: =A$1>=TODAY()
Choose color green.
Condition 2: Formula is: =A$1<VANDAAG()
Choose color red.
Now drag the colored cells across the rest of your data, which will look all screwed up for the moment, and look for a small square with dragging/carry through options. Select format only and your done.
Best regards,
Trowa
Start by selecting the cells of the column you want to color.
Activate conditional format.
Condition 1: Formula is: =A$1>=TODAY()
Choose color green.
Condition 2: Formula is: =A$1<VANDAAG()
Choose color red.
Now drag the colored cells across the rest of your data, which will look all screwed up for the moment, and look for a small square with dragging/carry through options. Select format only and your done.
Best regards,
Trowa