This should get you where you want. Use the Goto (I usually do ctrl-g) and
then click Special. Then click on Conditional Format and choose All or Same.
This will get you to the cells that have conditional formatting and then if
you have chosen Same, you can see what the CF is by the normal means:
Actually, after I tried this just now, I don't know if there is some reason
it is not working for me (like perhaps maybe too many cells that have the
same CF. I have seen it work in the past, but as of right now, the only time
I see what the CF is is when I choose just one cell and then look at
Format-Conditional Format. After further testing my limit SEEMS to be around
1600 rows (that's not exact though as my range starts on row 7. Also, I am
looking at 3 columns. If I look at just one column ...it again fails at row
1600 (but works at row 1599. I do not know if this is documented anywhere or
perhaps it is just a fluke on my workbook (I am using 2000 btw.)


--
Kevin Vaughn


"Kit" wrote:

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.