TV

Cell color is a format.

Conditional formatting will work on any cells you have set to be "unlocked"
even when the sheet is protected.

Otherwise you would need to use VBA to unprotect the sheet, make the color
change then re-protect.

Do you want to go this route?

Gord Dibben Excel MVP

On Mon, 29 Nov 2004 12:39:04 -0800, "TV" wrote:

Can I protect a sheet from format changes, but still be able to change cell
color? I am using Excel 2000.