View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Jazz Jazz is offline
external usenet poster
 
Posts: 45
Default Conditional Format

I need some help and direction. If Blue77 appears in any row in Column A, I
would like to change the format of that row columns A:K to color blue and
style bold. Here is what I am doing now.

Select range A2:K2
Format
Conditional Formatting
Formula Is
=$A$2=€¯Blue77€¯
Bold
Blue
Ok

It works for that row but I am not sure how to get it for all the rows with
the exception of row 1. Do you know?