If statement using date to change row colour
Solved/Closed
Z Kindo
Posts
1
Registration date
Monday March 3, 2014
Status
Member
Last seen
March 3, 2014
-
Mar 3, 2014 at 09:19 AM
Z Kindo - Mar 3, 2014 at 11:38 AM
Z Kindo - Mar 3, 2014 at 11:38 AM
Related:
- If statement using date to change row colour
- Fenix internet on bank statement - Guide
- Crimping colour code - Guide
- Change computer name cmd - Guide
- Saints row 2 cheats - Guide
- Facebook date of birth change - Guide
2 responses
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
December 27, 2022
555
Mar 3, 2014 at 11:11 AM
Mar 3, 2014 at 11:11 AM
Hi Z Kindo,
Well, Excel 2003 only has 3 conditional format rules, which requires a code to do what you want.
Since you are asking for formula's I'm assuming you have a later version of Excel.
Formula 1: =E2=""
Formula 2: =VANDAAG()-E2<=2
Formula 3: =VANDAAG()-E2<=5
Formula 4: =VANDAAG()-E2>5
Best regards,
Trowa
Well, Excel 2003 only has 3 conditional format rules, which requires a code to do what you want.
Since you are asking for formula's I'm assuming you have a later version of Excel.
Formula 1: =E2=""
Formula 2: =VANDAAG()-E2<=2
Formula 3: =VANDAAG()-E2<=5
Formula 4: =VANDAAG()-E2>5
Best regards,
Trowa