Conditional Formatting using Formula

[janema]

I'm trying to apply a formula to perform conditional formatting to highlight the cell if it doesn't equal the cell in a different column. Is that even possible? I used the conditional formatting tool, but my formula keeps getting rejected. Can anyone tell me what I'm doing wrong? I'm using the following formula to highlight and then will ask the cell to highlight a peach color:

=IF(O294<>N294)

 

[Fluff]

With the formula shown in post#5 all you need to do is remove the closing bracket.

 

[janema]

I never noticed until now that ST probably isn't a column label, it's two columns? S and T? Can't do that, right?
Are the cells you're trying to compare are merged S and T? The value would be in one or the other column but not as a combination.

Right. I am trying to conditionally format a column if it doesn't equal another column, but I guess that isn't possible with conditional formatting?

 

[janema]

With the formula shown in post#5 all you need to do is remove the closing bracket

It doesn't appear to be working accurately for some reason. If you see the image, it let me use =$Y4<>$T4 , but it is incorrectly highlighting those two you can see that are equal to each other.
It almost worked, but that, for example, should NOT be highlighted since they are equal to each other.

 

[Fluff]

The formula needs to reflect the row in the applies to range, so it should be looking at row 1 not row 4