Thread: Insert value based on color of the cell
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
aberdonian user aberdonian user is offline
external usenet poster
  
Posts: 2
Default Insert value based on color of the cell
Dear Experts,

I wonder if it is possible to insert value from a another cell based on the
color of the cell?

For example in A1:

=IF([Green],B1*30,IF([Yellow],B2*30,0))

Thank you in advance.

Regards,

Jim


Reply With QuoteReply With Quote