Formatting to highlight rows
 

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!

Formatting to highlight rows
 

Angie

Select entire rows or just the range in the 6 columns to format then
FormatConditional Formatting.

Formula is: =AND($E220000,$F215%)

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 FormatPatterns and OK your way out.


Gord Dibben MS Excel MVP

On Tue, 15 Aug 2006 14:10:02 -0700, Angie
wrote:

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!