Conditional Formatting

[David G.]

Hi! How can I conditionally format a range of cells so that they change
depending on today's date? For example, I want cells B1 and CI to have a
different color today; tomorrow, the color will return to normal for those
cells but change for B2 & C2, and son on. Data in columns B & C will have
numbers, not dates. Can this be done?

Thank you.

A B C

1 12/15 1500 1200

2 12/16

3 12/17

 

[T Kirtley]

Hi David,

In Excel 2003 you can do this by selecting the range you want to format,
click on Tools/Conditional Formatting and for the condition choose "Formula
Is" from the drop-down list and enter a formula such as:

=$A1=TODAY()

for the condition. Then click on the "Format" button to select the format to
use for rows with today's date. Click on OK and you should be good to go.

HTH,

TK

 

[FSt1]

hi
select b2.
in the CF dialog, enter =$A2=Today()
copy and Pastespecial fomats down as far as you need.
do the same with Column C

Regards
FSt1

 

[David G.]

Thks!

Hi David,

In Excel 2003 you can do this by selecting the range you want to format,
click on Tools/Conditional Formatting and for the condition choose "Formula
Is" from the drop-down list and enter a formula such as:

=$A1=TODAY()

for the condition. Then click on the "Format" button to select the format to
use for rows with today's date. Click on OK and you should be good to go.

HTH,

TK