Conditional Formatting

**hugrl** · 10-27-2009, 06:57 PM

I Need cell B6 to turn orange 30 days before date in cell C6 & cell C6 to turn red on date in C6

Can it be done?

Note date set as english dd/mm/yyyy does not have to stay as writen June
any help Appreciated

**JBeaucaire** · 10-27-2009, 08:12 PM

USE CONDITIONAL FORMATTING.

1) Highlight B6:B44
2) Select FORMAT > CONDITIONAL FORMATTING
3) Set Condition1: Formula Is:
=AND(B6>0,C6>0,C6-TODAY()<31)
4) Click on Format... Patterns: ORANGE
5) OK

1) Highlight C6:C44
2) Select FORMAT > CONDITIONAL FORMATTING
3) Set Condition1: Formula Is:
=AND(C6>0,TODAY()>=C6)
4) Click on Format... Patterns: RED
5) OK