Change the color of cells in one column when they don’t match cells in another column

by

  1. Select your range from cell A (or the whole columns by first selecting column A). Make sure that the ‘lighter coloured’ cell is A1 then go to conditional formatting, new rule:

    enter image description here

  2. Put the following formula and the choice of your formatting (notice that the ‘lighter coloured’ cell comes into play here, because it is being used in the formula):

    =$A1<>$B1

    enter image description here

  3. Then press OK and that should do it.

    enter image description here

Related Contents:

  1. How to return a result from a VBA function
  2. Function to convert column number to letter?
  3. Excel VBA App stops spontaneously with message “Code execution has been halted”
  4. How do I put double quotes in a string in vba?
  5. Simple Pivot Table to Count Unique Values
  6. Display milliseconds in Excel
  7. How to add a custom Ribbon tab using VBA?
  8. How to create an Excel File with Nodejs?
  9. What is the equivalent of “!=” in Excel VBA?
  10. Refreshing all the pivot tables in my excel workbook with a macro
  11. “Can’t find Project or Library” for standard VBA functions
  12. Test or check if sheet exists
  13. Last non-empty cell in a column
  14. How to turn a string formula into a “real” formula?
  15. Get length of array?
  16. How to put a tooltip on a user-defined function
  17. Save each sheet in a workbook to separate CSV files
  18. Is there a limit on an Excel worksheet’s name length?
  19. How can I URL encode a string in Excel VBA?
  20. How do I get countifs to select all non-blank cells in Excel?
  21. Ignore Duplicates and Create New List of Unique Values in Excel
  22. Getting unique values in Excel by using formulas only
  23. Convert string to int if string is a number
  24. How to get current working directory using vba?
  25. How to use the Implements in Excel VBA
  26. Generating random numbers with normal distribution in Excel
  27. Excel formula to get cell color [duplicate]
  28. Convert milliseconds to date (in Excel)
  29. OleDB & mixed Excel datatypes : missing data
  30. Pass row number as variable in excel sheet
  31. Does the VBA “And” operator evaluate the second argument when the first is false?
  32. Excel’s fullname property with OneDrive
  33. Case Function Equivalent in Excel
  34. reading Excel Open XML is ignoring blank cells
  35. IF a cell contains a string
  36. How can I create a calendar input in VBA Excel?
  37. Border around each cell in a range
  38. How to get the excel file name / path in VBA
  39. Excel compare two columns and highlight duplicates
  40. Why MS Excel crashes and closes during Worksheet_Change Sub procedure?
  41. How do you run a .exe with parameters using vba’s shell()?
  42. Is it possible to replace Excel’s VBA Editor/IDE with a modern alternative? [closed]
  43. Substitute a comma with a line break in a cell
  44. Closing Excel Application using VBA
  45. Reordering Chart Data Series [closed]
  46. How to disable Excel’s automatic cell reference change after copy/paste?
  47. Excel how to find values in 1 column exist in the range of values in another
  48. EXCEL VBA Check if entry is empty or not ‘space’
  49. Adding double quote delimiters into csv file
  50. Run Excel Macro from Outside Excel Using VBScript From Command Line

Leave a Comment