Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel 2007 conditional formatting & cell colour.
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! |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel 2007 conditional formatting & cell colour.
No formula, CF is the way.
Use formulae of =AND($B2<"",$A2<TODAY()-60) and =AND($B2<"",$A2<TODAY()-30) -- __________________________________ HTH Bob "chris_g" wrote in message ... 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! |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel 2007 conditional formatting & cell colour.
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. -- DLAYMANS "chris_g" wrote: 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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2007 Conditional formatting - change text colour when enteringsame name more than 3 times | Excel Discussion (Misc queries) | |||
Conditional Formatting Colour in a Column Graph (Excel 2003) | Excel Discussion (Misc queries) | |||
Apply conditional formatting to individual cell Excel 2007 | Excel Worksheet Functions | |||
change tab colour when using conditional formatting in a cell | Excel Worksheet Functions | |||
Conditional formatting: Colour coding | Excel Discussion (Misc queries) |