- 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
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: