Conditional Formatting: highlight row based on cell value

[dan_l]

Hi,

I just realized something: I totally suck at conditional formatting.

I have a report with fields:
[Part] [Type] [Sales]
1 A 1000
2 B 2000
3 A 1000

I want to highlight the entire row when the type is equal to A. I know it's setting up a

 

[KevinFlame]

If you are using Excel 2007 or above:

http://www.howtogeek.com/howto/45670/how-to-highlight-a-row-in-excel-using-conditional-formatting/

 

[sudipto3003]

hi dan,
go through the following link.........
http://forum.chandoo.org/threads/conditional-formatting-for-a-table-range.14498/