Mar 19 2022 06:51 AM
I'm useless at Excel -- but I have a 3000+ row sheet in which I'd like to be able to highlight with text
colour, where a cell in (say) col D differs from a cell in (say) col M in the same row.
I'm sure there's a simple way, but I've struggled for many hours without success, so I hope for enlightenment here...
Here's a SS of a faked dummy sheet which I hope shows the sort of thing I'm after:
Mar 19 2022 06:56 AM
Conditional formatting can help make patterns and trends in your data more apparent.
Use conditional formatting to highlight information
ou can apply conditional formatting to a range of cells (either a selection or a named range), an Excel table, and in Excel for Windows, even a PivotTable report.
Hope I was able to help you with this information.
I know I don't know anything (Socrates)
Mar 19 2022 07:02 AM
SolutionSelect the range you want to format conditionally, say D1:D100.
The active cell in the selection should be the topmost cell, in this example D1.
On the Home tab of the ribbon, click Conditional Formatting > New Rule...
Select 'Format only cells that contain'.
Leave the first drop-down set to 'Cell Value'.
Select 'not equal to' from the second drop-down.
In the box next to it, enter the formula =M1 where M is the column you want to compare to and 1 is the row number of the active cell.
Click Format...
Activate the Font tab.
Select a font color.
Click OK, then click OK again.
Mar 19 2022 08:19 AM
Mar 19 2022 09:16 AM
Mar 19 2022 07:02 AM
SolutionSelect the range you want to format conditionally, say D1:D100.
The active cell in the selection should be the topmost cell, in this example D1.
On the Home tab of the ribbon, click Conditional Formatting > New Rule...
Select 'Format only cells that contain'.
Leave the first drop-down set to 'Cell Value'.
Select 'not equal to' from the second drop-down.
In the box next to it, enter the formula =M1 where M is the column you want to compare to and 1 is the row number of the active cell.
Click Format...
Activate the Font tab.
Select a font color.
Click OK, then click OK again.