View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Ola[_5_] Ola[_5_] is offline
external usenet poster
 
Posts: 7
Default =ColorCell(Color)

I want to create a function that Colors the Active Cell based on a certain
criteria.
Example:
A1: 10
B1: =ColorCell(A1)

I want to use it instead of conditional formatting since I want the
flexibility - so I can use all 56 colors. Also I want =ColorCell(A1) to
return "" (=blank)

Is this possible?
Ola