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>
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

conditional format 2
Conditional Format (Todays Date) 2
conditional formating 2
date popping up in error 2
Changing cell colors 1
[Flashing] RED before renewal date 1
Conditional Formatting in Excel 2007 1
graphical indicator 1

Top