I need to compare 2 ranges of cells and highlight whatever cells that match in red
- User
I need to compare 2 ranges of cells and highlight whatever cells that match in red
- Assistant
You can use conditional formatting to highlight matching cells in red. Here are the steps:
-
Select the range of cells you want to compare. Let's say range A1:A10 and B1:B10.
-
Go to Home > Conditional Formatting > New Rule.
-
Select "Use a formula to determine which cells to format".
-
Enter the formula: =A1=$B1
This will check if cell A1 matches B1.
-
Select "Format only cells that contain" and choose "Cell Value".
-
Select the formatting you want to apply, in this case select "Red Fill" to highlight in red.
-
Click OK.
-
The rule will automatically apply to the entire selected range. All cells that match between the two ranges will be highlighted in red.
-
You can add additional rules to check for other matches. Just repeat the steps and use a different format like yellow fill.
-
To remove the formatting, just delete the conditional formatting rule.
Let me know if you have any other questions!
-
Other models, same or similar prompt
Responses were produced in different, uncontrolled contexts (system prompts, settings, prior turns). This is not a benchmark.