Answer for:

Using Conditional Formatting in Excel with different results

Message 2 of 2

View entire thread
0 Votes

If your numbers are stored in the range A2:A8 and your letters are stored in the range B2:B8

Select the range B2:B8 and create two new rules (Select Use a formula to determine which cells to format).

First rule, =AND(A2<>4,A2<>5,COUNTIF($A$2:$A$8,A2)>1), Blue Fill Format
Second rule, =OR(A2=4,A2=5), Green Fill Format

If you don't know how to create a new rule, please visit: