Conditional Formatting

R

Randy

Need help changing one cell (red, green, yellow) based on a date range of two
other cells. If current date is (before, during or after) date range turn a
certain cell a color.

Thanks,
Randy
 
G

Gord Dibben

Assuming dates are in A1 and B1

Select C1 and Format>CF>Condition1>Formula is: =B1<A1 format to a color

Add>Condition2>Formula is: =B1=A1 format to a color

Condition3 will be =B1>A1


Gord Dibben MS Excel MVP
 
R

Randy

Thanks - what I'm looking for is the following:

Yes, dates are in A1 and B1 (Date Range)

1. If today's date<A1 format to a color
2. If today's date is equal to or greater than A1 and equal to or less than
B1 format to a color
3. If today's date>B1 format to a color

Thanks,
Randy
 
D

David Biddulph

CF Condition 1: Formula Is =TODAY()<A1
CF Condition 2: Formula Is =TODAY()<=B1
CF Condition 3: Formula Is =TODAY()>B1 (but this could be your default
colour setting)
 
R

Randy

Thanks!
I think we're getting close and maybe I'm just not getting this but:

Condition 2 only works if my date is equal to or less than B1. I need
Condition 2 to be: if today is equal to/less than B1 but also equal
to/greater than A1 change color. Also the three conditions will have
different colors.

Condition 1 = Color1
Condition 2 = Color2
Condition 3 = Color3
 
D

David Biddulph

Did you try it?
As far as condition 2 is concerned, you don't need the test for >=A1,
because if <A1 it will have satisfied condition 1, and thus not got to test
2. Similarly condition 3 isn't strictly necessary, which is why I said the
default colour will do.
When you insert each conditiion in CF, you can set the appropriate colour
with each.
 
R

Randy

Sometimes you should just stop asking questions and just do
it..........Thanks! It worked.

Regards,
Randy
 
Top