Try without absolute row reference

=$A2=€�Blue77€�

If this post helps click Yes
---------------
Jacob Skaria


"Jazz" wrote:

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?