View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
NickHK NickHK is offline
external usenet poster
 
Posts: 4,391
Default Can I change the colours on a spreadsheet with an if formula?

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
...