Forum Discussion
Cond. format: each cell in one col based on same row in another col
Select 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.
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)