title: How to show value in cell depending on its filled color - event in Excel VBA
body: <p>In Excel I would like to show value in current cell depending on its filled color ( something like IFCOLOR() ). Excel should do this automatically when I change filled color therefore it should be event.</p>
  
  <p>For example:
  When I fill cell in green then Excel automatically shows value 100
  When I fill cell in red then automatically Excel shows value 75
  and so on ...</p>
  
  <p>Is it possible do this by event in Excel VBA? Or can you give me other ideas how to do it?</p>
  
  <p>I used <code>Workbook_SheetChange</code> but this works when I change value in cell not its background color.</p>
  
  <p>Regards
  Jan</p>