Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Conditional Formatting
It would be much simpler if you would shade the cells in
column C using the FormatConditional Formatting menu. Agreed, you'd have to update this format once a year. -----Original Message----- I have a list of equipment that needs to be inspected every 2 Years in column "A". In column "B", I enter the date the inspection was carried out, as 12/11/01. Column "C" displays the next due date for the inspection as 12/11/03. I would like in column "D" all inspections displayed that are due for inspection for the current year. In this example I would like to have the cell in column "D", representing this equipment shaded in a blue colour. How would I do this? Any suggestions greatly appreciated. . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formatting Conditional Formatting Icon Sets | Excel Discussion (Misc queries) | |||
Protect Cell Formatting including Conditional Formatting | Excel Discussion (Misc queries) | |||
conditional Formatting based on cell formatting | Excel Worksheet Functions | |||
conditional Formatting based on cell formatting | Excel Worksheet Functions | |||
Conditional Formatting that will display conditional data | Excel Worksheet Functions |