View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Marcelo Marcelo is offline
external usenet poster
 
Posts: 1,047
Default How do I display all conditional formatting in Excel?

hi Kit,

try this,

http://www.j-walk.com/ss/excel/usertips/tip045.htm

also you could see the formulas on the cell with Ctrl+~ or TOOLS | OPTIONS

hth
regards from Brazil
Marcelo

"Kit" escreveu:

Whilst it is possible to display all the formulas on an Excel 2003 worksheet,
it is only possible to display conditional formatting cell-by-cell. This is
tedious when checking for any errors, which are easy to acquire when pasting
from one cell to another.