View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
henriques henriques is offline
external usenet poster
 
Posts: 13
Default Conditional Formatting

I need a cf that color all the rows that meet a condition of a cell.
Example:
Column B as 6 different values in rows. If the value from B1 to B30 is equal
to S, D or F, then all that rows change color to blue.

Thanks in advance for the support