Formatting to highlight rows

[Guest]

I have a worksheet with 6 columns of data. I want to have the rows
highlighted if data in 2 columns is over a certain number. For example, if
column E2 is over 20,000 and F2 is over 15%, I want to highlight the entire
row yellow. Does anyone know how to set this up?

Thanks!

 

[Gord Dibben]

Angie

Select entire rows or just the range in the 6 columns to format then
Format>Conditional Formatting.

Formula is: =AND($E2>20000,$F2>15%)

Note the $ signs must be as shown to lock columns E and F reference but not the
rows reference.

Pick a pretty color from the Format>Patterns and OK your way out.


Gord Dibben MS Excel MVP