View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Angie Angie is offline
external usenet poster
 
Posts: 79
Default 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!