Hi,
If I press "Ctrl+~" I can see all the formulas on my excell.
Is there any way that I can see all the conditional
formatting and/or the validation at once?
Thank you.
Rubem
Hi,
If I press "Ctrl+~" I can see all the formulas on my excell.
Is there any way that I can see all the conditional
formatting and/or the validation at once?
Thank you.
Rubem
Press F5 > Special > Conditional formats (or Data validation) > OK
(there's a lot of other useful options available
in the Go To Special dialog <g>)
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <at>yahoo<dot>com
----
"Juran54" <[email protected]> wrote in message
news:[email protected]...
> Hi,
>
> If I press "Ctrl+~" I can see all the formulas on my excell.
>
> Is there any way that I can see all the conditional
> formatting and/or the validation at once?
>
> Thank you.
>
> Rubem
Max,
Thank you.
What I meant was, that I would like to see is what I wrote
in the conditional and/or validation.
Juran
>-----Original Message-----
>Press F5 > Special > Conditional formats (or Data
validation) > OK
>
>(there's a lot of other useful options available
>in the Go To Special dialog <g>)
>--
>Rgds
>Max
>xl 97
>---
>GMT+8, 1=B0 22' N 103=B0 45' E
>xdemechanik <at>yahoo<dot>com
>----
>"Juran54" <[email protected]> wrote in
message
>news:[email protected]...
>> Hi,
>>
>> If I press "Ctrl+~" I can see all the formulas on my excell.
>>
>> Is there any way that I can see all the conditional
>> formatting and/or the validation at once?
>>
>> Thank you.
>>
>> Rubem
>
>
>.
>
"Juran54" <[email protected]> wrote
....
> What I meant was, that I would like to see is what I wrote
> in the conditional and/or validation.
Ok, think there's a Sub DataValDocumenter()
and a sample file at Debra's page:
http://www.contextures.com/xlDataVal09.html
Document a Worksheet's Data Validation
which would prove useful for DV
But I couldn't find something equivalent for Conditional Formatting, like a
"Sub CondFormatDocumenter()", despite some honest hard efforts trawling the
vast google archives ..
Hang around awhile for better insights from others ..
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <at>yahoo<dot>com
----
I created a page with similar code for Conditional Formatting
documentation. It lists the conditions, font colour, and fill colour.
You could modify the code to list other formats.
http://www.contextures.com/xlCondFormat04.html
Max wrote:
> "Juran54" <[email protected]> wrote
> ...
>
>>What I meant was, that I would like to see is what I wrote
>>in the conditional and/or validation.
>
>
> Ok, think there's a Sub DataValDocumenter()
> and a sample file at Debra's page:
>
> http://www.contextures.com/xlDataVal09.html
> Document a Worksheet's Data Validation
>
> which would prove useful for DV
>
> But I couldn't find something equivalent for Conditional Formatting, like a
> "Sub CondFormatDocumenter()", despite some honest hard efforts trawling the
> vast google archives ..
>
> Hang around awhile for better insights from others ..
> --
> Rgds
> Max
> xl 97
> ---
> GMT+8, 1° 22' N 103° 45' E
> xdemechanik <at>yahoo<dot>com
> ----
>
>
--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html
Thanks Debra !
Fresh from the oven .. <g>
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <at>yahoo<dot>com
----
Debra, just thought it would be useful* to have a similar instructions
textbox in this (CondFormatDoc.xls) sample file, as was done for
DataValDocumenter.xls.
*Especially the part on where the text file (Test.txt) would be created
(I had a tough time <g> wondering where this text file went to, when I ran
the sub ..)
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <at>yahoo<dot>com
----
Good point. <g> Thanks for the suggestion -- I've added the text box
with instructions.
Max wrote:
> Debra, just thought it would be useful* to have a similar instructions
> textbox in this (CondFormatDoc.xls) sample file, as was done for
> DataValDocumenter.xls.
>
> *Especially the part on where the text file (Test.txt) would be created
> (I had a tough time <g> wondering where this text file went to, when I ran
> the sub ..)
> --
> Rgds
> Max
> xl 97
> ---
> GMT+8, 1° 22' N 103° 45' E
> xdemechanik <at>yahoo<dot>com
> ----
>
>
--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html
You're welcome !
(I did a subtle re-check .. <g>)
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <at>yahoo<dot>com
----
Good -- I wouldn't trust me either. <g>
If you notice anything in the code that should be changed, please let me
know.
Max wrote:
> You're welcome !
> (I did a subtle re-check .. <g>)
> --
> Rgds
> Max
> xl 97
> ---
> GMT+8, 1° 22' N 103° 45' E
> xdemechanik <at>yahoo<dot>com
> ----
>
>
--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html
"Debra Dalgleish" <[email protected]> wrote
> Good -- I wouldn't trust me either. <g>
>
> If you notice anything in the code that should be changed, please let me
> know.
Sure .. Cheers.
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <at>yahoo<dot>com
----
Debra and Max,
Thank you for you suggestion. I will try it. I did not
know that by simple question will open for a high level
discussion which unfortunately I cannot participate.
Juran
>-----Original Message-----
>Thanks Debra !
>Fresh from the oven .. <g>
>--
>Rgds
>Max
>xl 97
>---
>GMT+8, 1=B0 22' N 103=B0 45' E
>xdemechanik <at>yahoo<dot>com
>----
>
>
>.
>
"Juran54" <[email protected]> wrote
> Debra and Max,
> Thank you for you suggestion. I will try it.
You're welcome !
> I did not know that by simple question will open for a high
> level discussion which unfortunately I cannot participate.
Why not? It's also thanks to you for this post which precipitated
the development of the cond format documenter subroutine
by Debra for the benefit of all <g> Cheers.
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <at>yahoo<dot>com
----
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks