Conditional Formatting Help
Closed
Lauren
-
Jun 1, 2015 at 05:21 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Jun 2, 2015 at 11:41 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Jun 2, 2015 at 11:41 AM
Related:
- Conditional Formatting Help
- Excel formula to change cell color without conditional formatting - Excel Forum
- Excel conditional formatting if another cell contains specific text - Excel Forum
- How to clear formatting in excel - Guide
- 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
- Phone formatting software for pc - Download - File management
1 response
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
December 27, 2022
552
Jun 2, 2015 at 11:41 AM
Jun 2, 2015 at 11:41 AM
Hi Lauren,
Select the number of rows you want to apply conditional format, starting with the 2nd row > conditional format > new rule > use formula:
Formula 1: =AND($I2<>"",$I2<TODAY(),$J2="")
Formula 2: =AND($I2=TODAY(),$J2="")
Best regards,
Trowa
Select the number of rows you want to apply conditional format, starting with the 2nd row > conditional format > new rule > use formula:
Formula 1: =AND($I2<>"",$I2<TODAY(),$J2="")
Formula 2: =AND($I2=TODAY(),$J2="")
Best regards,
Trowa