damian_r_Home
Board Regular
- Joined
- Jan 8, 2005
- Messages
- 231
- Office Version
- 365
- 2007
- Platform
- Windows
Howdo.
Yes this should be simple but as somebody only once in a blue moon has to now create spreadsheets, I can't figure out what to do and so your help is appreciated with the formulas
Cell G4 either has a date in it or is empty.
If empty, no conditional formatting should occur whatsoever.
If G4 contains a date, the following needs to apply.
If the value in cell I4 EQUALS 100 then no conditional formatting should apply
If the date is within the next 14 days of =TODAY(), then the cell should have an amber background
If the date is before =TODAY() and a value in I4 is less than 100, the cell needs to format red background
I think that's all i need, I just cant remember how to get an IF statement to work in the conditional formatting options
Yes this should be simple but as somebody only once in a blue moon has to now create spreadsheets, I can't figure out what to do and so your help is appreciated with the formulas
Cell G4 either has a date in it or is empty.
If empty, no conditional formatting should occur whatsoever.
If G4 contains a date, the following needs to apply.
If the value in cell I4 EQUALS 100 then no conditional formatting should apply
If the date is within the next 14 days of =TODAY(), then the cell should have an amber background
If the date is before =TODAY() and a value in I4 is less than 100, the cell needs to format red background
I think that's all i need, I just cant remember how to get an IF statement to work in the conditional formatting options