Forum Discussion
Excel for Mac - Conditional formatting if same cells in 2 different sheets have different values
I am trying to set up a simple way to scan a complex spreadsheet that is updated periodically by another person so I can quickly see the changes they have made. My thought was to apply conditional f...
≠ is not valid in Excel. To specify 'not equal to', you have to use <>
='8-18-23 Compare'!$B$4<>'3-12-23'!$B$4
Please note that this will only look at cell B4. If you want to compare more cells, select the entire range, and use
='8-18-23 Compare'!B4<>'3-12-23'!B4
where B4 is the top left cell in the selection.
- Thank you Hans. I'm used to constructing formulas in FileMaker Pro, which does accept ≠.
Neil
