Hi All
Felt the need to share. I often work on large sheets with lots of data and many formulas. To reduce calc time I often replace formulas with values but leave the formulas in the first row for refreshing purposes.
Recently I found it useful to use conditional formatting to highlight cells with formulas.
Select the data portion of the sheet, say A2:Z50
Add CF rule
Formatting based on formula
Formula: =isformula(a2)
Select the highlight colour required.
Hope this is helpful for someone.
Ron
ISFORMULA function
Applies To: Excel for Office 365 Excel for Office 365 for Mac Excel 2016 Excel 2013 Excel 2016 for Mac Excel for Mac 2011 Excel Online Excel for iPad Excel for iPhone Excel for Android tablets Excel for Android phones Excel Mobile
I don't see Excel 2010 as your profile show
Useful to know, thanks for sharing
On a side note - please update your profile as necessary to properly reflect the exact version(s) of Excel your question relates to. Members tailor answers based on your Excel version. Your profile says 2010, but I believe =isformula() is only available in later versions?
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
will do, I hadn't noticed the version there.
No problem, thanks for updating
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks