and your are right.
i made a mistake because i didn't test first. oops.
and i suppose it could be simplified. but works = works and don't work =
don't work.
avoid don't work.

regard
FSt1

"David Biddulph" wrote:

For a CF formula of =IF(C1=A1,1,0) you could simplify it to =C1=A1
but I think the OP wanted =C1<A1
--
David Biddulph

"FSt1" wrote in message
...
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?