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

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

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

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.