moe10134
Board Regular
- Joined
- Sep 8, 2005
- Messages
- 162
- Office Version
- 2019
- Platform
- Windows
Hi.
I'm looking for a conditional formatting formula that reads one number for lookup to determine the color formatting in next column. The lookup value of (1,2,3) represents how many times the number to the left appears in the column. I'm looking for a conditional formatting formula to highlight each (1-85762542) number because there are 2. And a different color for any 3's, etc. I hope this makes sense.
Any suggestions?
Thanks -
Ex.
1-85762541 1
1-85762542 2
1-85762543 3
1-85762544 1
1-85762542 2
1-85762546 1
1-85762547 1
1-85762543 3
1-85762549 1
1-85762550 1
1-85762543 3
I'm looking for a conditional formatting formula that reads one number for lookup to determine the color formatting in next column. The lookup value of (1,2,3) represents how many times the number to the left appears in the column. I'm looking for a conditional formatting formula to highlight each (1-85762542) number because there are 2. And a different color for any 3's, etc. I hope this makes sense.
Any suggestions?
Thanks -
Ex.
1-85762541 1
1-85762542 2
1-85762543 3
1-85762544 1
1-85762542 2
1-85762546 1
1-85762547 1
1-85762543 3
1-85762549 1
1-85762550 1
1-85762543 3