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.

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.

Marcelo/Kit

John's tip will only identify cells that have CF, not display the actual CF
Formula is:

You could do the same by F5>Special>CF cells.

I saw code once for getting the CF formulas onto a new sheet but have lost the
location.

Will keep looking.


Gord Dibben MS Excel MVP

On Fri, 7 Jul 2006 08:27:02 -0700, Marcelo <(E-Mail Removed)>
wrote:

>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.

Hi Gord,

thanks for the feedback, i realy appreciate it

regards from Brazil
Marcelo

"Gord Dibben" escreveu:

> Marcelo/Kit
>
> John's tip will only identify cells that have CF, not display the actual CF
> Formula is:
>
> You could do the same by F5>Special>CF cells.
>
> I saw code once for getting the CF formulas onto a new sheet but have lost the
> location.
>
> Will keep looking.
>
>
> Gord Dibben MS Excel MVP
>
> On Fri, 7 Jul 2006 08:27:02 -0700, Marcelo <(E-Mail Removed)>
> wrote:
>
> >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.
>
>

Thanks to both of you for your prompt responses! But the problem is not yet
solved. To indicate which cells have conditional formatting is one thing, to
display the actual CFs which are there - in all the cells at once - is quite
another!
I use the CF in constructing a rota. Weeks are in separate columns and
anyone not available that week is placed in 5 or six cells at the bottome of
each column. The conditional formatting turns the text red if I inadvertently
place someone on duty that week. This ought to be foolproof! It is only when
something changes the CF that it doesn't work This results in me having to
do a tedious check of all the cells to see if errors have crept in. If I
could see a full screen of CFs - and even print it - this would be
time-saving.

Regards to you both from England,

Kit

"Marcelo" wrote:

> 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.

Kit

I know the code is out there...............just have to locate.


Gord

On Fri, 7 Jul 2006 12:19:02 -0700, Kit <(E-Mail Removed)> wrote:

>Thanks to both of you for your prompt responses! But the problem is not yet
>solved. To indicate which cells have conditional formatting is one thing, to
>display the actual CFs which are there - in all the cells at once - is quite
>another!
>I use the CF in constructing a rota. Weeks are in separate columns and
>anyone not available that week is placed in 5 or six cells at the bottome of
>each column. The conditional formatting turns the text red if I inadvertently
>place someone on duty that week. This ought to be foolproof! It is only when
>something changes the CF that it doesn't work This results in me having to
>do a tedious check of all the cells to see if errors have crept in. If I
>could see a full screen of CFs - and even print it - this would be
>time-saving.
>
>Regards to you both from England,
>
>Kit
>
>"Marcelo" wrote:
>
>> 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.

Gord Dibben MS Excel MVP

Thanks Gord!
Signing off for today (20:38 BST here)

Kit

"Gord Dibben" wrote:

> Kit
>
> I know the code is out there...............just have to locate.
>
>
> Gord
>
> On Fri, 7 Jul 2006 12:19:02 -0700, Kit <(E-Mail Removed)> wrote:
>
> >Thanks to both of you for your prompt responses! But the problem is not yet
> >solved. To indicate which cells have conditional formatting is one thing, to
> >display the actual CFs which are there - in all the cells at once - is quite
> >another!
> >I use the CF in constructing a rota. Weeks are in separate columns and
> >anyone not available that week is placed in 5 or six cells at the bottome of
> >each column. The conditional formatting turns the text red if I inadvertently
> >place someone on duty that week. This ought to be foolproof! It is only when
> >something changes the CF that it doesn't work This results in me having to
> >do a tedious check of all the cells to see if errors have crept in. If I
> >could see a full screen of CFs - and even print it - this would be
> >time-saving.
> >
> >Regards to you both from England,
> >
> >Kit
> >
> >"Marcelo" wrote:
> >
> >> 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.
>
> Gord Dibben MS Excel MVP
>

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.

Oops. When I started my reply there was only one reply and it did not look
like it addressed the issue. Now, after I posted I see that there were
several responses and my reply was not what you were after. Unfortunately, I
started looking at the web page (I am viewing this from microsoft.com) a
couple hours ago and neglected to refresh the page (to see if there were any
new posts) before posting. Sorry about that.
--
Kevin Vaughn


"Kevin Vaughn" wrote:

> 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.

Thanks for your time and well-informed efforts, Kevin!
Your phrase "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" hits the nail on the head! The fact that you have
seen it work in the past gives me some hope!!

As I write this, I have not yet tried your instructions,but thought I would
drop you a quick word of thanks before doing so.

Kit



"Kevin Vaughn" wrote:

> Oops. When I started my reply there was only one reply and it did not look
> like it addressed the issue. Now, after I posted I see that there were
> several responses and my reply was not what you were after. Unfortunately, I
> started looking at the web page (I am viewing this from microsoft.com) a
> couple hours ago and neglected to refresh the page (to see if there were any
> new posts) before posting. Sorry about that.
> --
> Kevin Vaughn
>
>
> "Kevin Vaughn" wrote:
>
> > 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.