Skip to content
The Chat Archive
claude-1· Anthropic Arena Human Preference 55K

I need to compare 2 ranges of cells and highlight whatever cells that match in red

  1. User

    I need to compare 2 ranges of cells and highlight whatever cells that match in red

  2. Assistant

    You can use conditional formatting to highlight matching cells in red. Here are the steps:

    1. Select the range of cells you want to compare. Let's say range A1:A10 and B1:B10.

    2. Go to Home > Conditional Formatting > New Rule.

    3. Select "Use a formula to determine which cells to format".

    4. Enter the formula: =A1=$B1

    This will check if cell A1 matches B1.

    1. Select "Format only cells that contain" and choose "Cell Value".

    2. Select the formatting you want to apply, in this case select "Red Fill" to highlight in red.

    3. Click OK.

    4. The rule will automatically apply to the entire selected range. All cells that match between the two ranges will be highlighted in red.

    5. You can add additional rules to check for other matches. Just repeat the steps and use a different format like yellow fill.

    6. To remove the formatting, just delete the conditional formatting rule.

    Let me know if you have any other questions!

Responses were produced in different, uncontrolled contexts (system prompts, settings, prior turns). This is not a benchmark.