Formatting to highlight rows

  • Thread starter Thread starter Guest
  • Start date Start date
G

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!
 
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
 
Back
Top