CODEWITHSUNDEEP
excelconditional-formattingexcel-2010
b_dev
b_dev

Reputation: 2598

Conditional formatting cells within a date range in Excel 2010?

I want to do this pseudo formula below:

IF CELL VALUE < TODAY() + 60 , THEN FORMAT CELL RED

to these spreadsheet cells :

alt text

I am having trouble with Conditional Formatting in EXCEL 2010

Upvotes: 1

Views: 58846

Answers (3)

Ranga
Ranga

Reputation: 64

In Excel, do the following:

  • Go to the Home Tab
  • Select the values which need to be conditionally formatted
  • Click Conditional Formatting >> New Rule...
  • In the dialog, select Format only cells that contain
  • At the bottom of the dialog:
    • Change the first drop-down to Cell Value
    • Change the second drop-down to Less Than
    • Change the third block to be =Today() + 60
  • Click Format..., set the font to RED, then click OK
  • On the New Formatting Rule dialog, click OK

Once you Apply, you will see your highlighting show up.

Upvotes: 4

charstar
charstar

Reputation: 1167

You might have better luck with this question over at the superuser stackexchange. A quick grok of the questions there reference this page on conditional formatting.

Upvotes: 0

sha
sha

Reputation: 17860

There is Conditional Formatting button in Styles menu in Excel 2007. Should be something similar in 2010, no?

Upvotes: 0

Related Questions