Conditional Formatting Help

[simong81]

Hi all,

I am pretty new to using excel for anything more than a simple table. I have added some simple VBA to the document to allow a drop down tick option using wingdings 2.

What I now want to do is add some conditional formatting that should columns N to AN have a tick "P" in them and columns J, K, L or M have a tick then it turns one of four colours.

Can anyone please advice how to do this in a simple way?

Thanks

Simon

 

[simong81]

I am currently using four formulas which work on one cell but I cant seem to change or copy to work in all the cells i need.

=AND(J6="P", N6="P")
=AND(K6="P", N6="P")
=AND(L6="P", N6="P")
=AND(M6="P", N6="P")

Each of these have a different colour outcome. Your help would be greatly appreciated.

 

[Special-K99]

Try

=AND($J6="P", $N6="P")
=AND($K6="P", $N6="P")
=AND($L6="P", $N6="P")
=AND($M6="P", $N6="P")

Use Format painter (paintbrush icon) to copy to other cells

 

[simong81]

Hi,

Thanks for the reply but that doesnt seem to be working for some reason?

Any other ideas?