Rhodestransit
New Member
- Joined
- Feb 8, 2011
- Messages
- 41
I want to do something more with a conditional format setting
here are my formulas
=COUNTIF(C$3:AU$80,C3)>1
=COUNTIF(C$3:AU$80,F3)>1
I want to make it ignore data that is the same in 2 specified cells but still highlight other duplicates.
So if the same data is in C3 and F3 do not highlight it
but if the same data is in C3 and F9 for example i still want to highlight it
I also want a way to auto copy data from C3 to F3 without undoing any conditional formats
here are my formulas
=COUNTIF(C$3:AU$80,C3)>1
=COUNTIF(C$3:AU$80,F3)>1
I want to make it ignore data that is the same in 2 specified cells but still highlight other duplicates.
So if the same data is in C3 and F3 do not highlight it
but if the same data is in C3 and F9 for example i still want to highlight it
I also want a way to auto copy data from C3 to F3 without undoing any conditional formats
Last edited: