Excel Formula Help

  dads3a 11:17 14 Apr 10

I have a master budget spreadsheet and a KPI spreadsheet.

On the budget sheet we a have a task listing in numbers. This cant be altered.

On the KPI sheet we have the tasks linked to the budget sheet and in column B we are trying to set up an incomplete task amount.

On the budget sheet we fill the cell in green to show a complete task.

So in column B of the KPI sheet is there a way that when the cell is filled green it will pick up the value of that cell.

many Thanks

  Pineman100 12:26 14 Apr 10

I'll bump you to the top in the hope that the mighty VoG will spot this.

  VoG II 12:38 14 Apr 10

There are no native functions in Excel for working with cell colours. A better way than colouring the cells (or perhaps as well as) would be to use a spare column (let us say X) and mark completed tasks using an X. Your formula in column B would then be something like


  Pineman100 12:42 14 Apr 10

You see? It's a bit like shining the VoGâ„¢light into the sky!


This thread is now locked and can not be replied to.

Nintendo Switch review: Hands-on with the intuitive modular console and its disappointing games…

1995-2015: How technology has changed the world in 20 years

The updated 'Corel Painter inside Photoshop' plugin ParticleShop offers new brushes

Best running headphones | Best sport & fitness headphones: 4 brilliant pairs of wireless…