Conditional Formating
 

Dear all,

I would like to apply a conditional formating to fill with a red colour some
Excel cells when the computer calendar gets some date, I would like to fill
that cells when "best before date" of some pruducts gets that date with the
computer calendar.

Thanks a lot.
Pedro Mestre

One way:

If cell A1 is active:

CF1: Formula is =TODAY()=A1
Format1: Patterns/red



In article ,
Pedro Mestre wrote:

Dear all,

I would like to apply a conditional formating to fill with a red colour some
Excel cells when the computer calendar gets some date, I would like to fill
that cells when "best before date" of some pruducts gets that date with the
computer calendar.

Thanks a lot.
Pedro Mestre

Pedro,

Lets say the date you is 06/20/05 in A1

Click on the cell you want to fill in, then lick on FORMAT-- CONDITIONAL
FORMAT on toolbar

A window will pop up and you will see on the left an option of "Cell Value
Is". Change the option to "Formula Is"

In the section to the right of "Formula Is", enter the following formula:
=AND(A1<"",TODAY()=A1)

Now, click on FORMAT in this window, then PATTERNS. Just click the color
you want. Then click OK, and OK again.

Not really understanding how you are using this, the above formula will only
work for that one day that the dates match. If you want it to fill red for
that day and every day afterwards, then make the last part of formula read
TODAY()=A1)

Hope this helps.
Les




"Pedro Mestre" wrote:

Dear all,

I would like to apply a conditional formating to fill with a red colour some
Excel cells when the computer calendar gets some date, I would like to fill
that cells when "best before date" of some pruducts gets that date with the
computer calendar.

Thanks a lot.
Pedro Mestre