Conditional Formatting

[bresab]

Hi folks having a problem with conditional formatting I have a database columns A to K. What I want to do is format a cell in column A if the corresponding cell in column K says "Sch"

I highlight cells a2:a300

I open the conditional formatting box with is formula= $k2$:$k300$="sch"

but it doesn't work can anyone help and tell me what I am doing wrong

Cheers

 

[JoeMo]

Change the formula to:

= $k2="sch"

Then set the format you want.

 

[bresab]

Joemo your a star would never had got that in a million

Cheers