Excel 2007 conditional formatting & cell colour.

C

chris_g

Hi All,

I was hoping someone may be able to offer some practical advice regarding
conditional formatting of cell colour.

I have made a sheet to track the status of orders placed and recieved:
Column A is the order placed date, and column B is the recieved date, which
remains empty until a known date can be entered.

As there a large number of records (rows) and I am having to manually check
for orders recived within a certain date, I was hoping there may be a way to
format the fill colour (make yellow) of column B after 30 days have elapsed.
In addition, make the cell red after 60.

I think this must be possible to impliment as a formula in the conditional
formatting section which i have spent an age tinkering with.

Can anyone offer any possible solution or examples of cell colour being
changed dependent on the content of a neighbour cell? I'm new to this, but
feel i could piece it together I had a few simple examples of working fomula
to play with.

Is there a formula to change the background colour of a cell?

Thanks for any help you can offer!
 
B

Bob Phillips

No formula, CF is the way.

Use formulae of

=AND($B2<>"",$A2<TODAY()-60)

and

=AND($B2<>"",$A2<TODAY()-30)
 
D

DLAYMANS

Go to format, click on Conditional Formatting,, 1st cell, change condition 1
to "Cell Value Is" 2nd cell make it read "between" 3rd cell show "31" 4th
cell to "59" then click on Format, select your color. This will make the
cell turn yellow when the cell is between 31 and 59.

Next click the add button to add another condition. Duplicate the same
process but in the 3rd cell type "60" the 4th cell type "750". This will
change the cell color to red when the number is between 60 and 760.

Hope this helps.
 

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

Top