Forum Discussion
Solved
Cond. format: each cell in one col based on same row in another col
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 ...
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.
Write Formula > B2 = D2 in Col F you will get result True or False then filter False and bingo there you go select all and colr them > shortcut
OR
Write If Formula in conditional formatting hoping you know it if not do let me know
OR
Write If Formula in conditional formatting hoping you know it if not do let me know