conditional formatting true or false

[savino714]

hello everyone, im trying to color code only "true" for this formula with conditional formatting. the true is in column b3 but start date in a1 and todays date in e1? how should the formula be with conditional formatting for true? please help

 

[T. Valko]

hello everyone, im trying to color code only "true" for this formula with conditional formatting. the true is in column b3 but start date in a1 and todays date in e1? how should the formula be with conditional formatting for true? please help

Not clear.

How do dates relate to what you want to do? You haven't explained that.

Is there a formula in B3 that returns TRUE or FALSE?

 

[savino714]

Not clear.

How do dates relate to what you want to do? You haven't explained that.

Is there a formula in B3 that returns TRUE or FALSE?

yes the formula is in b3 is =a1<e1} I want true to be color coded all the way down row b for true

 

[savino714]

the formula is on b3 as =a1<e1} want to color code all b column only true?

 

[T. Valko]

yes the formula is in b3 is =a1

<E1} p true for b row down way the all coded color be to want I QUOTE]< true[> OK, so what is the condition that must be met for the conditional formatting to be applied?

Also, tell us what version of Excel you're using?

 

[savino714]

in conditional formatting to get the color code do I put in =a1<e1,"true"

 

[T. Valko]

in conditional formatting to get the color code do I put in =a1

OK, let's try this...

You said there is a start date in cell A1 and today's date in cell E1.

Cell B3 contains this formula: =A1

You want to apply some kind of conditional formatting to cell B3. So what date does cell B3 have to contain in order for that formatting to be applied?

 

[savino714]

=a1<e1,"true" do I put that in conditional formatting to color b colum true

 

[savino714]

=a1<,"today" thats in b3

 

[savino714]

column b3 has true