Conditional Formatting Based on Two Cells

Question

I have added some VBA coding to a document using Wingdings 2 P to create ticks. I now want to add some conditional formatting so that if two cells have P (the tick symbol) then they turn a colour. I can get it working in one cell but when I try to copy the formula it won't work. The formula I have put in is:

=AND(M6="P", N6="P")

Can anyone help?

pnuts · Accepted Answer · 2014-09-15 20:32:34Z

2

I think you may want a CF formula of the kind:

=AND($M6="P",$N6="P")

but it does somewhat depend upon what you would like formatted subject to the condition/s.

answered Sep 15, 2014 at 20:32

pnuts

59.8k11 gold badges93 silver badges141 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Conditional Formatting Based on Two Cells

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related