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

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.