View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Biff
 
Posts: n/a
Default Highlighting an entire row using conditional formatting.

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" wrote
in message ...

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 ?


--
SystemHack
------------------------------------------------------------------------
SystemHack's Profile:
http://www.excelforum.com/member.php...o&userid=26614
View this thread: http://www.excelforum.com/showthread...hreadid=505232