D dzelnio Jul 5, 2007 #1 If the name "Dave" appears in B3, I want C3-Z3 to have a blue background color. What's that formula? dzelnio
If the name "Dave" appears in B3, I want C3-Z3 to have a blue background color. What's that formula? dzelnio
G Gord Dibben Jul 5, 2007 #2 Select C3:Z3 and Format>Conditional Formatting>Formula is: =$B3="Dave" Format to Blue. Gord Dibben MS Excel MVP
Select C3:Z3 and Format>Conditional Formatting>Formula is: =$B3="Dave" Format to Blue. Gord Dibben MS Excel MVP
D dzelnio Jul 5, 2007 #3 Works great! Thanks Dave Select C3:Z3 and Format>Conditional Formatting>Formula is: =$B3="Dave" Format to Blue. Gord Dibben MS Excel MVP Click to expand...
Works great! Thanks Dave Select C3:Z3 and Format>Conditional Formatting>Formula is: =$B3="Dave" Format to Blue. Gord Dibben MS Excel MVP Click to expand...
