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
- How to clear formatting in excel - Guide
- Phone formatting software for pc - Download - File management
- Formatting usb mac - Guide
- Code for formatting android phone - Guide
- Openoffice conditional formatting - Guide
1 response
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
December 27, 2022
555
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