| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
CONDITIONAL FORMATTING BASED ON RESULTS IN A CELL
SCENARIO
I have an Excel sheet which contains dates in row 1 and the corresponding days in row 2. The days are derived using formulas. For instance, B1 carries the date 26 June 2006 and had been formatted to display 26. B2 = B1, and had been formatted to display the day as MON. CHALLENGE I want to apply a conditional formatting (apply a background) to all the cells that display MON. I also wish to know if it is possible to apply conditional formatting to a particular cell based on a condition in a different cell. Ie. in the above example, is it possible to conditionally format the entire column B based on cell B2? Regards |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Merged Cell Conditional Formatting Borders | Excel Discussion (Misc queries) | |||
| Conditional formatiing based on another cell | Excel Discussion (Misc queries) | |||
| Conditional cell background formatting, based on cell content | Excel Discussion (Misc queries) | |||
| Conditional formatting of an entire row based on a cell text entry | Excel Discussion (Misc queries) | |||
| Trying to add conditional formatting to every other cell...GOING . | Excel Worksheet Functions | |||
Threaded Mode
