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.

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.

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.

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.