Posted to microsoft.public.excel.misc
|
|
Find Cells with Formulas
glad to help
regards
FSt1
"RJB" wrote:
Good stuff. Easy to do, tough to explain to my colleagues.
Thanks for the quick reply!
rjb
"FSt1" wrote:
hi
for conditional formatting to highlight formulas see this site.....
http://ccnotes.wordpress.com/2006/11/10/22/
regards
FSt1
"RJB" wrote:
I inherited a spreadsheet with 52 tabs of tables, each table 21 columns by 8
rows.
MOST cells have a VLOOKUP formula in them, the rest, someone has plugged in
a number.
Is there a way to conditionally format the sheet to show which ones do NOT
have a formula?
I know Ctrl + ` will SHOW formulas, but I'd like to highlight them.
(So I guess my Subject line is backwards)
|