Excel Formula Help

  dads3a 11:17 14 Apr 2010
Locked

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 2010

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

  VoG II 12:38 14 Apr 2010

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

=IF(Budget!X2="X",Budget!B2,"")

  Pineman100 12:42 14 Apr 2010

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

;o)

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

Elsewhere on IDG sites

Galaxy Note 8 vs iPhone X

Awful clip art from 1994 is being tweeted every hour by a bot

How to update iOS on iPhone or iPad

Les meilleures applications pour enfants 2017