Conditional Formatting - with dates

[TG2812]

Hi,

I have the following table:

	Target	Jan-17	Feb-17	Mar-17	Mar-18	Jun-19	Jul-19	Sep-19	Dec-20
My sales	3	3	1	5	1	4	1	6	1

<tbody>
</tbody>

In the conditional formatting i have entered "if cell in range C2:J2 is less than target cell ($B2) then color in blue" -> $E2<$C$2:$J$2

Any idea of to instruct Excel not to color the cell if dates in the header belong to the past (preferably to embed it in the above condition).

Thank you.

 

[Fluff]

How about
=AND(C2< $B2,C1 >TODAY())

 

[TG2812]

Hi Fluff,

Thank you very much for your help.
Can you please describe the steps to include your formula into the conditional formatting menu?

 

[Fluff]

Yup
Select C2:J2 (or c2:J & last row) > CF > New Rule > Use a formula > Enter the formula > Format > select your format > Ok > Ok.

If you have more than one row use
=AND(C2<$B2,C$1>TODAY())