Whilst previewing Open Office (.org) I noticed a nice feature which auto highlights input values (ie non formula cells). Makes it easy for a user of the sheet to know where to input data. Does anyone know if excel can do this?
Last edited by VBA Noob; 12-24-2008 at 12:59 PM.
You can get close to this by selecting all the cells, hit F5, Special,Precedents.
Once you have the selection, colour it.
This only works if you have one level of formulae. If you have multiple levels, the intermediate formulae are selected as well.
Martin
Eighty Twenty Spreadsheet Automation http://homepage.ntlworld.com/martin.rice1/ for all your Excel customisation and consulting needs.
If my solution has saved you time and/or money, please consider donating to Cancer Research UK.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks