If you mean with a cell formula or UDF then No; a function cannot change its
environment, only return a value.
May be you need Conditional Formatting.
NickHK
"Changing Cell Colours with an If formula" <Changing Cell Colours with an If
wrote in message
...