Thanks for the clarification. Now I understand how it works.

"Jim Rech" wrote:

Conditional formatting overrides regular formatting. So the only way to
change the formatting that conditional formatting creates is to change the
conditional formating rules or the conditional formatting format. To get an
idea of the code you'd use to do that record a macro as you change it
manually.

--
Jim
"Sarah" wrote in message
...
Does anyone know how to override conditional formatiing with code?

Thanks,

Sarah