Parlablane
09-26-2005, 08:24 AM
Greetings All from a Newbie to the boards.
I have an Excel file (zip attached) that shows the utilisation of various network switches we have on site.
I've managed to get it count how many ports are in use (count cells in yellow) and how many ports are available in a room (count cells using a certain font and subtract those which are already in use (coloured yellow).
But (and this is a big but) I cannot make the formula auto run when I change the colour of a cell. If I change the value of the cell the formula will update, but I don't do that. I just change the colour of the cell.
At the moment, I have to double click and hit enter for each cell that I want to update.
My question is - "Can I set Excel to automatically upate each cell when anything is changed?" or "Is it possible to add a button the will run all formula on a page?"
Any help or suggestions would be very welcome.
Thank you all.
I have an Excel file (zip attached) that shows the utilisation of various network switches we have on site.
I've managed to get it count how many ports are in use (count cells in yellow) and how many ports are available in a room (count cells using a certain font and subtract those which are already in use (coloured yellow).
But (and this is a big but) I cannot make the formula auto run when I change the colour of a cell. If I change the value of the cell the formula will update, but I don't do that. I just change the colour of the cell.
At the moment, I have to double click and hit enter for each cell that I want to update.
My question is - "Can I set Excel to automatically upate each cell when anything is changed?" or "Is it possible to add a button the will run all formula on a page?"
Any help or suggestions would be very welcome.
Thank you all.