Conditional Formatting

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
 
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
 
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)
 
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
 
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.
 
Sometimes you should just stop asking questions and just do
it..........Thanks! It worked.

Regards,
Randy
 
Back
Top