Highlighting an entire row using conditional formatting.

[SystemHack]

I know how to use conditional formatting to apply a format to a certain
cell if it's value is a certain range or item.

Is there any way to highlight the entire rown containing that item if
it matches ?

For example, I have columns A, B, and C. If column C = X , I want to
highlight the entire row (A, B, C) for that entry.

Any way to do this ?

 

[Biff]

Hi!

Select the range of cells in question. I'll assume A1:C1

Conditional Formatting
Formula is: =$C$1="x"
Set your format(s)
OK out

Biff

 

[SystemHack]

ok .. problem with this is I have something like 500 rows .. I would
have to sit and enter that for each row individually .. would take
forever. Any shorter ways ?

 

[Biff]

Select the range of cells. I'll assume it's A1:C500

Formula is: =$C1="x"

Biff

 

[SystemHack]

Works absolutely perfect man .. thanks !!

I know have already helped alot but would you mind explaining how you
get that formula ? If not no biggie .. it's doing what I need thanks.

 

[David McRitchie]

The cells to be colored are based on the selection, so you
selected all cells -- well you could have anyway.

The formula is based on the active cell and determines whether
the cell will be colored.
If A1 is the active cell and you used
=A1=1 then each cell would be evaluated against 1
If you use $A1 in stead of the active cell then each cell
will be evaluated to what is in column A and the active
cell could be any cell on row 1.

More information on Conditional Formatting
http://www.mvps.org/dmcritchie/excel/condfmt.htm