Conditional formatting based on a cell's contents

[Budget Programmer]

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 are: 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.

 

[Max]

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"
Format>Blue fill
Condition 2: =$B1="Green"
Format>Green 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]

Hi Max,
That was it. Thanks for the help.

 

[Max]

Glad to hear. You're welcome.
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:23,500 Files:370 Subscribers:66
xdemechanik