Format column based on values in other columns

This is my data set, I am trying to create a rule that will highlight unique values

STATEMENT 1   STATEMENT 2  
E 23.73 D 582.7
A 413.47 A 413.47
B 430.37 B 430.37
C 83.64 C 83.64
D 582.7 F 88.13

I know there is a rule where I can highlight two columns and format unique values, for example if I choose columns B and D, then choose to highlight unique values the numbers 23.73 and 88.13 would be highligted.

 

What I want is to also highlight the adjacent values in columns A and C. Using the above example I would also want the cells containing E and F to be highlighted, since E and F are the “names” of the values to the right.

 

Here is an exame of what I’d want to see based on this rule:

STATEMENT 1   STATEMENT 2  
E 23.73 D 582.7
A 413.47 A 413.47
B 430.37 B 430.37
C 83.64 C 83.64
D 582.7 F 88.13

 

How can I do this?

By: Bran

One thought on “Format column based on values in other columns

  1. Bran

    I just realized I wasn’t very clear.

    I don’t just want the cells in columns A and C highlighted for being unique, I want them highlighted because the cells **adjacent** to them in columns B and D are unique.

    For example E is highlighted because 23.73 is a unique value when comparing columns B and D, F is highlighted because 88.13 is a unique value when comparing columns B and D.

Leave a Reply

Your email address will not be published. Required fields are marked *