| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional formatting based on a cell's contents
Hello,
I'm using Excel 2007 and want to know if something possible through the user interface. I'd like to change the background color of columns A through H in each Row based on the value of that row's column B. All column B values are restricted via Data validation. The five permissible values a Blue, Green, Yellow and Red and blank. I expect that I'd use Conditional Formatting, but I can't seem to find out how to use that functionality to change the background color of each row's A-H range based on the text value in column B. I can use a Macro / VB solution if I have to, but I want to exhaust the user interface first. Many thanks for all your help. -- Programmer on Budget |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| 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) | |||
| Conditional Format based on other cell's value | Excel Worksheet Functions | |||
| Applying conditional formatting to cell based on another cell's in | Excel Discussion (Misc queries) | |||
| Conditional Formating for a cell based on another cell's value | Excel Discussion (Misc queries) | |||
Threaded Mode
