| 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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Conditional formatting based on a cell's contents
The key is to use the $ sign to fix the point to col B
In xl2003, select entire cols A to H (A1 active) then apply via the CF's Formula is: Condition 1: =$B1="Blue" FormatBlue fill Condition 2: =$B1="Green" FormatGreen fill .... etc OK out Try the equivalent steps in your xl07 If you get it up, celebrate the success by clicking YES below -- Max Singapore http://savefile.com/projects/236895 Downloads:23,500 Files:370 Subscribers:66 xdemechanik --- "Budget Programmer" wrote: 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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Conditional formatting based on a cell's contents
Hi Max,
That was it. Thanks for the help. -- Programmer on Budget "Max" wrote: The key is to use the $ sign to fix the point to col B In xl2003, select entire cols A to H (A1 active) then apply via the CF's Formula is: Condition 1: =$B1="Blue" FormatBlue fill Condition 2: =$B1="Green" FormatGreen fill ... etc OK out Try the equivalent steps in your xl07 If you get it up, celebrate the success by clicking YES below -- Max Singapore http://savefile.com/projects/236895 Downloads:23,500 Files:370 Subscribers:66 xdemechanik --- "Budget Programmer" wrote: 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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Conditional formatting based on a cell's contents
Glad to hear. You're welcome.
-- Max Singapore http://savefile.com/projects/236895 Downloads:23,500 Files:370 Subscribers:66 xdemechanik --- "Budget Programmer" wrote in message ... Hi Max, That was it. Thanks for the help. |
| Reply |
| 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) | |||
Linear Mode
