DarkJester89
Board Regular
- Joined
- Nov 5, 2017
- Messages
- 109
- Office Version
- 2016
- Platform
- Windows
Column H- Day last edited
Column F- Station completed
If H is less than 30 days and F is >10 = Format Green
If H is greater than 30 days and F is > 10 = Format Green
If H is greater than 30 days and F is <10 = Format Red
The red works when it's rule1, but green does not and I apply it H column
Any suggestions?
Images
Column F- Station completed
VBA Code:
=AND($F2<>10, $H2-30<=TODAY())
If H is less than 30 days and F is >10 = Format Green
Code:
=AND($F2<>10, $H2-30>TODAY())
If H is greater than 30 days and F is > 10 = Format Green
Code:
=AND($F2<10, $H2-30<=TODAY())
If H is greater than 30 days and F is <10 = Format Red
The red works when it's rule1, but green does not and I apply it H column
Any suggestions?
Images