Conditional Format
 

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

Conditional Format
 

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



In article ,
Kevin wrote:

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

Conditional Format
 

Hey thanks,

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

"JE McGimpsey" wrote:

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



In article ,
Kevin wrote:

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.

Conditional Format
 

Formula Is =B1 <= TODAY()


--


Regards,


Peo Sjoblom



"Kevin" wrote in message
...
Hey thanks,

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

"JE McGimpsey" wrote:

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



In article ,
Kevin wrote:

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