No, but you can add conditional formatting to the cell, and test the value
there and set the format accordingly.

--
HTH

Bob Phillips

"neeses" wrote in message
...
We run a macro that selects duplicates and formats with background with a
color. We need to include that cell formatting in an IF statement. Can it
be
done and, if so, what would be the syntax?