Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Changing Background Colour Based on Cell Contents
Firstly a bit of background. I have a report which is run from a seperate
database to determine candidates who have not been contacted for more than six weeks. I export the results of the report into excel and run a macro to delete uneccessary information, and to "pretty up" the spreadsheet. Information on the spreadsheet is calculated with a formula which is input bu the macro, and determines the number of weeks since the candidates were last contacted, i.e. =(today()-b3)/7, in column E. I was wondering whether it was possible to edit the code to determine how long it has been since the cadidate was last contacted, and based on that, colour the cell either, red, yellow or green. Thanks in advance |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Changing Cell Background Color based on data from another cell | Excel Discussion (Misc queries) | |||
Changing background colour when changing data in a cell | Excel Discussion (Misc queries) | |||
Changing Cell Contents Colour | Excel Discussion (Misc queries) | |||
Changing background color based on different cell | Excel Discussion (Misc queries) | |||
Formula for changing colour of a cell based on Neumeric VALUE | Excel Discussion (Misc queries) |