That will need VBA, unless the fill colour is derived from conditional
formatting (in which case you could impose an equivalent condition).
--
David Biddulph

"Janie" wrote in message
...
I would like to create an "If" logical function formula, where the "true"
condition is based on the format of the cell.

For instance, if cell b3 is formatting with a fill color, then add that
number; if not, then add zero.

Can anyone help?