| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional formatting based on Cell Value and another cell's valu
In Excel 2007...
If E50 and E3="x" I want E5 to be shaded red. How can I accomplish this? Even better would be: If E50 and E3="x" I want E5 to be shaded "the same color as E3" (that is, to use the shaading of E3 as a variable. Doubt that's possible). Any help is GREATLY appreciated! jb |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Conditional formatting based on a cell's contents | Excel Discussion (Misc queries) | |||
| Conditional Formatting an entire row based on one cell's value. | Excel Discussion (Misc queries) | |||
| Conditional Formatting for Rows based on one cell's outcome | Excel Discussion (Misc queries) | |||
| Formatting a cell with colour based on whether another cell's valu | Excel Worksheet Functions | |||
| Applying conditional formatting to cell based on another cell's in | Excel Discussion (Misc queries) | |||
Threaded Mode
