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


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