please help me

[Jagat Pavasia]

I have some text and digit in A1 to J1, but i want that if i type "O.K." in K1 then all line A1 to J1 changed to Blue Color.

 

[lrobbo314]

Select the data in Columns A-J and add a Conditional Format. Add a formula as your conditional format. The formula is =$K1="O.K."

Then just choose a blue background color.

 

[Jagat Pavasia]

it is done but i want this type from K1 to K60, give me formula

 

[arunsjain]

When you apply conditional formatting then choose A1:J60.

=$K1="O.K" will work for rest of the rows as well.

Refer to link for more explanation https://www.youtube.com/watch?v=YAzK9vHa178