Can I call up and use the Conditional Formatting dialog in
a way that I can use the results of the entries without
overwriting what is currently designated for conditional
formatting?

My users want to be able to assign more than three
conditional formats to a cell. Excel has a limit of three
and will error out if you try to assign more. This would
be simple if they were just looking at the results of a
calculation and formatting based on the outcome. What
they are doing, however, is comparing the results to a
different cell. So, when they copy the conditional
formatting, the cell locations the comparisons are being
made to are being copied too. They want to be able to set
it up once and copy it across the rows.

The way I thought I might handle it was to let them set up
the conditional formatting for the first two conditions.
This would be assigned to the cells. Then they could pull
up my copy of the dialog box -- I would take their input
and only apply it to the cells that ended up not getting
the format changed by the first pass of conditional
formatting. I hope this makes sense!

Can I do this? Can I use Microsoft's form in my own way?
I want to offer the functionality of displaying a sample
of the formatted cell and the way they can click and
choose ranges, etc. Plus they are familiar with the
current Conditional Formatting form.

TIA for any help or advice.

~~Jody

It sounds like they just need to learn how to use absolute cell references.

If you show the dialog, it should pick up existing settings for the selected
cells - showing the dialog from code should be identical to showing it by
selecting it from the menu.

If you already know how you want the condition set, it seems you could just
do it in code - not sure where the user interaction is needed.

--
Regards,
Tom Ogilvy

"jody" wrote in message
...
Can I call up and use the Conditional Formatting dialog in
a way that I can use the results of the entries without
overwriting what is currently designated for conditional
formatting?

My users want to be able to assign more than three
conditional formats to a cell. Excel has a limit of three
and will error out if you try to assign more. This would
be simple if they were just looking at the results of a
calculation and formatting based on the outcome. What
they are doing, however, is comparing the results to a
different cell. So, when they copy the conditional
formatting, the cell locations the comparisons are being
made to are being copied too. They want to be able to set
it up once and copy it across the rows.

The way I thought I might handle it was to let them set up
the conditional formatting for the first two conditions.
This would be assigned to the cells. Then they could pull
up my copy of the dialog box -- I would take their input
and only apply it to the cells that ended up not getting
the format changed by the first pass of conditional
formatting. I hope this makes sense!

Can I do this? Can I use Microsoft's form in my own way?
I want to offer the functionality of displaying a sample
of the formatted cell and the way they can click and
choose ranges, etc. Plus they are familiar with the
current Conditional Formatting form.

TIA for any help or advice.

~~Jody