Conditional Format

K

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.
 
J

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>
 
Top