Question

compare two cells in excel and highlight differences

Answer 1

Answer:

On your computer, open a spreadsheet in Google Sheets.

Select the range you want to format. For example, cells A1 to A100. Click Format Conditional formatting.

Under the "Format cells if" drop-down menu, click Custom formula is. Write the rule for the first row.

Choose other formatting properties.

Click Done ...