Conditional Formatting

[WGarrison]

Hello. I have a very simple sheet. I am trying to compare column G with Column K and if the values are not equal, conditional format them. This should be a very simple formula but it is not working. The formula I have for the conditional formatting is attached in the image. I should see results in row 17 and I am not. What am I doing wrong?

The only thing I can think of, I have a nested IF statement in column K and it doesn't like comparing hard value to an IF statement.

 

[Special-K99]

Remvoe the IF(...) so it just reads $G2<>$K2, what you're are looking for is a condition when TRUE, so no IF required.
You might need to remove the $ too, so its just G2<>K2

 

[KOKOSEK]

remove quotes and change into:

$G2<>$K2

 

[Peter_SSs]

I suggest that you update your Account details (or click your user name at the top right of the forum) so helpers always know what Excel version(s) & platform(s) you are using as the best solution often varies by version. (Don’t forget to scroll down & ‘Save’)
You refer to various columns and rows in your description but we cannot see either in your image.

Your CF formula has quotes around it. Remove those and also change the formula to simply
=G2<>K2
Also make sure the "2"s in that formula are the same as the row of the active cell. Your image looks like the active cell might actually be row 1 - but hard to tell from the image.

For the future:
I suggest that you investigate XL2BB for providing sample data & expected results to make it easier for helpers to understand just what you have & where it is and also what you want & where it is to be. If you have trouble with XL2BB review the "XL2BB Icons greyed out" link in the 'Known XL2BB issues' section near the top of the XL2BB Instructions page linked above.