find number < 60 and highlight Red

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a column of dates B and a column of today's Date C; 10/04/04. I have
column d that subtracts B from C to give me a number. I want to find all
numbers in column C that are less than 60 and highlight them RED.... or
another formatting to make them stick out.
 
Use conditional formatting. You want Formula Is (instead of Cell Value Is),
and type the formula =D2<60, and set the format. I referred to cell D2. That
reference should be to whatever cell is active when you set up the formatting.
 
You must log in or register to reply here.

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

Function Help - Forecast Date past due, adjacent cell is blank. Needto highlight the blank cell. 2
SUM Q 2
Counting dates with Conditional Formatting 13
Count entries in the column translating to minutes. 5
Conditional formatting of dates in two cells using Excel 2007 2
SUM - IF - AND 7
Conditional Formatting with Icon Sets 0
Unhide column difficulty 3

Back
Top