Highlight range of cells bases on 1 cell

[wmtsub]

I am trying to set a conditional format where if A1="T" then cells A1:P! are set to a specific color.
I can only get it to work in A1, cant get it to color the rest of the cells.
can anyone help?

 

[Marcelo Branco]

Select A1:P1; in Conditional Formatting try this formula
=$A1="T"

M.

 

[arthurbr]

Select A1:P1
Then use =$a1="T" as CF and format as required

 

[wmtsub]

Thanks. Maybe the $ I was using was messing this up.