Using conditional formatting in Excel 2007
 

This is probably a stupid question, but I am creating a database, in which I
want the cells in ex. range A2:G57 to highlight a certain color, but only if
the cell in the same row has a value of 1. Please understand that I don't
want all of the cells (A2:G57) to change, just the cells on the same row as
the cell that =1.

Any help is greatly appreciated. Please reply as if you're speaking to an
idiot who has never used Excel... Cause you are...

Thanks.

Using conditional formatting in Excel 2007
 

For Example:


A B C D E
1 Text Text Text Text 0
2 Text Text Text Text 0
3 Hi-Text Hi-Text Hi-Text Hi-Text 1
4 Text Text Text Text 0
5 Hi-Text Hi-Text Hi-Text Hi-Text 1

I want to format all cells A1:D5 to be formatted to highlight if the Cell in
column E = 1.

Using conditional formatting in Excel 2007
 

Don't have/know xl2007,
but Fwiw, in xl2003, it's as easy as ...

Selecting cols A to E (A1 active), then
Clicking Format Conditional Formatting,
applying it using Formula Is: =$E1=1,
then Formatting the font to taste

... illustrated here with a screencap of the range selection/CF dialog:
http://www.freefilehosting.net/download/3bgb9
CF rows based on col E value.xls

And if you don't want col E to be CF'd, just exclude it in the selection of
the cols (first step)
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Gunnar Boykin" wrote in message
...
For Example:


A B C D E
1 Text Text Text Text 0
2 Text Text Text Text 0
3 Hi-Text Hi-Text Hi-Text Hi-Text 1
4 Text Text Text Text 0
5 Hi-Text Hi-Text Hi-Text Hi-Text 1

I want to format all cells A1:D5 to be formatted to highlight if the Cell
in
column E = 1.

Using conditional formatting in Excel 2007
 

Select the whole range, use
Home tab | Styles group | Conditional Formatting - New Rule - Use a
Formula ....
Enter =$E1=1 and set the fill or font colour as needed
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"Gunnar Boykin" wrote in message
...
For Example:


A B C D E
1 Text Text Text Text 0
2 Text Text Text Text 0
3 Hi-Text Hi-Text Hi-Text Hi-Text 1
4 Text Text Text Text 0
5 Hi-Text Hi-Text Hi-Text Hi-Text 1

I want to format all cells A1:D5 to be formatted to highlight if the Cell
in
column E = 1.