| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel spreadsheet change colour of cell back ground depending on d
Hi Guys
I have an excel spreadsheet that i use for insurance details. I would like to have a formula set up so i know 2months / 60days away from when an insurance expires. I would like another colour for when the insurance has expired and new details are over due. Thanks look forward to your response Natalie |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel spreadsheet change colour of cell back ground depending on d
See http://www.xldynamic.com/source/xld.CF.html#due
-- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Nataliec" wrote in message ... Hi Guys I have an excel spreadsheet that i use for insurance details. I would like to have a formula set up so i know 2months / 60days away from when an insurance expires. I would like another colour for when the insurance has expired and new details are over due. Thanks look forward to your response Natalie |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how do i change cell background colour depending on its content? | Excel Discussion (Misc queries) | |||
| how can make company logo as excel sheet back ground ? | Excel Discussion (Misc queries) | |||
| How can i change cell colour depending on month of date in cell? | Excel Discussion (Misc queries) | |||
| back ground color doesn't work in cell. | Excel Worksheet Functions | |||
| I want print excel sheet with nos in the back ground, as shown in. | Excel Discussion (Misc queries) | |||
Linear Mode
