Changing Color of the Cell under Certain Conditions


Joined
Nov 24, 2009
Messages
12
Reaction score
0
Pretty sure this is called conditional formatting, but anyway I need a formula that will give me:

If the data in cell A1 does not match data anywhere else on the sheet (and there will be text in cell A1),
Then change color of A1
And it needs to be repeated, as in, if no data matches B1, then change color of B1... etc.

if thats impossible, then it'd help to know this:

If cell A1 matches cell M1 (and there will be text in these cells, not numbers)
Then change color of A1
 
Last edited:
Ad

Advertisements

Ad

Advertisements

Ad

Advertisements


Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top