| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Not enough conditional formatting
Hi there,
I have created a calendar to help me in my work and I need to highlight certain dates in different colour pending on if the cell next to it has a value or not, I have devised 5 values but can only have a maximum of 3 conditional formatting options. W = Week end - back ground red - foreground black B = Bank holiday - background light blue - foreground Black Bold I = Inset day - Background light yellow - foreground Blue Bold H = Holiday - Background light gray - foreground Black Bold D = Half day - background light brown - foreground Blue Bold X = Tradining day - no change from general settings assuming that B8 has Value "B" then B8 and C8 background light blue foreground Black Bold is it possible? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| 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 Q | Excel Worksheet Functions | |||
| Conditional Formatting that will display conditional data | Excel Worksheet Functions | |||
Threaded Mode
