color according to name

[dzelnio]

If the name "Dave" appears in B3, I want C3-Z3 to have a blue
background color.

What's that formula?

dzelnio

 

[Gord Dibben]

Select C3:Z3 and Format>Conditional Formatting>Formula is:

=$B3="Dave"

Format to Blue.


Gord Dibben MS Excel MVP

 

[dzelnio]

Works great!

Thanks

Dave

Select C3:Z3 and Format>Conditional Formatting>Formula is:

=$B3="Dave"

Format to Blue.

Gord Dibben MS Excel MVP