Using conditional formatting in Excel 2007

  • Thread starter Thread starter Gunnar Boykin
  • Start date Start date
G

Gunnar Boykin

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)
 
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
 
Back
Top