Thread: Can RGB fill color be automated based on 3 cell values?
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Phil Hibbs Phil Hibbs is offline
external usenet poster
  
Posts: 100
Default Can RGB fill color be automated based on 3 cell values?
micky wrote:
Maybe: [A4].Interior.Color = Evaluate(RGB([A1], [A2], [A3]))
Micky

You'd have to put that in a Worksheet_Change macro.

Phil Hibbs.
Reply With QuoteReply With Quote