I've tried all of the above suggestions, none work. I should probably also
say that column c is currently empty and I'm needing it to change when I put
the number in. If the number matches the corresponding cell in a then it
would stay the same, if it is higher or lower it needs to change to a
specified color.

Thanks

"FSt1" wrote:

hi
select C1.
on the menu bar....
formatcontitional format
formula is......=IF(C1=A1,1,0)
pick your format.

Regards
FSt1

"Kelly P" wrote:

I have an excel spreadsheet that if say c1 doesn't equal a1 then I want to
change the color in c1. How would I set this up?