| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Changing cell or text color depending on week number
Hi all
I have an job that requires the contents of a cell to change color depending on how many weeks there are yet to run before the job is due. ie a visual 'heads up' of what is coming up. Contents or text would follow like this - If due this week, RED, if due next week, orange, if due in two weeks, yellow, if due in 3 weeks, green. As the project is based on week numbers, it would be best for the formula to based on that. Regards Roger |
|
#2
|
|||
|
|||
|
If you have 3 conditions or less, you can use the Conditional Formatting
option under the Format menu. You can specify the cell value for the conditional format or you can select "Formula Is" under the drop down and type your formula there. -Sharon "Roger" wrote: Hi all I have an job that requires the contents of a cell to change color depending on how many weeks there are yet to run before the job is due. ie a visual 'heads up' of what is coming up. Contents or text would follow like this - If due this week, RED, if due next week, orange, if due in two weeks, yellow, if due in 3 weeks, green. As the project is based on week numbers, it would be best for the formula to based on that. Regards Roger |
|
#3
|
|||
|
|||
|
Thanks Sharon,
The Conditional Formatting is a little limited for what I want to do. I'd like more options than the 3 provided for, but I'm not sure about how to do it...! Roger "Sharon" wrote in message ... If you have 3 conditions or less, you can use the Conditional Formatting option under the Format menu. You can specify the cell value for the conditional format or you can select "Formula Is" under the drop down and type your formula there. -Sharon "Roger" wrote: Hi all I have an job that requires the contents of a cell to change color depending on how many weeks there are yet to run before the job is due. ie a visual 'heads up' of what is coming up. Contents or text would follow like this - If due this week, RED, if due next week, orange, if due in two weeks, yellow, if due in 3 weeks, green. As the project is based on week numbers, it would be best for the formula to based on that. Regards Roger |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Why doesn't text wrap in a cell in Excel? | Excel Discussion (Misc queries) | |||
| How to reference a text cell that changes weekly in Header or Foo. | Excel Discussion (Misc queries) | |||
| On click, copy text into another cell - XL2K | Excel Worksheet Functions | |||
| Why is my text changing to pound signs? | Excel Discussion (Misc queries) | |||
| Formatting a cell as "text" in the number catagory. | Excel Worksheet Functions | |||
Linear Mode
