Conditional Format

[Kevin]

I would like to make a conditional format for column B, I would like the cell
to turn red if it is today’s date and yellow if it is 3 days from today.

 

[JE McGimpsey]

One way:

Select column B, with B1 the active cell.

Choose Format/Conditional Formatting and set the dropdowns and
inputboxes to:

CF1: Formula Is =B1 = TODAY()
Format1: <patterns>/<red>

CF2: Formula is =B1 = TODAY() + 3
Format2: <patterns>/<yellow>

 

[Kevin]

Hey thanks,

Now how do I get it to stay red if it past todays date?

 

[Peo Sjoblom]

Formula Is =B1 <= TODAY()


--


Regards,


Peo Sjoblom