View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
RJB RJB is offline
external usenet poster
 
Posts: 86
Default Find Cells with Formulas

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)