Editing conditional formats (Excel 2010)

[Vidcapper]

To me, this seems a lot more complicated than in Excel 2003 which I'm
used to?

In 2003, you just choose the cell(s), select Format-Conditional
Formatting, then away you go.

In 2010 though, while you can select multiple cells at once to view
their formatting, I can't see any way of, say, selecting formats in
multiple cells, then deleting them all at once?

Is there a way to do this, or do I have to go through a laborious 4 or 5
click method on every individual cell?

I hope this makes sense!

 

[Claus Busch]

Hi Paul,

Am Wed, 13 Nov 2013 12:13:41 +0000 schrieb Vidcapper:

In 2010 though, while you can select multiple cells at once to view
their formatting, I can't see any way of, say, selecting formats in
multiple cells, then deleting them all at once?

select your cells => Conditional Formatting => Clear Rules and then you
can choose Clear Rules from selected cells or Clear rules from entire
sheet.
Another way:
Conditional Formatting => Manage Rules and then you can also choose
Current Selection or This Worksheet and you can edit or delete the rules


Regards
Claus B.

 

[Vidcapper]

Hi Paul,

Am Wed, 13 Nov 2013 12:13:41 +0000 schrieb Vidcapper:


select your cells => Conditional Formatting => Clear Rules and then you
can choose Clear Rules from selected cells or Clear rules from entire
sheet.
Another way:
Conditional Formatting => Manage Rules and then you can also choose
Current Selection or This Worksheet and you can edit or delete the rules

Will this delete all the rules from the selected cells, though? I'm
trying to delete just *some* of them.

I'll have to experiment - thanks.

 

[Claus Busch]

Hi,

Am Wed, 13 Nov 2013 14:38:27 +0000 schrieb Vidcapper:

Will this delete all the rules from the selected cells, though? I'm
trying to delete just *some* of them.

then you have to do it with Conditional Formatting => Manage Rules =>
Current Selection.
There you can choose which rule should be deleted.


Regards
Claus B.

 

[Vidcapper]

Hi,

Am Wed, 13 Nov 2013 14:38:27 +0000 schrieb Vidcapper:


then you have to do it with Conditional Formatting => Manage Rules =>
Current Selection.
There you can choose which rule should be deleted.

OK, thanks.

 

[Vidcapper]

Hi,

Am Wed, 13 Nov 2013 14:38:27 +0000 schrieb Vidcapper:


then you have to do it with Conditional Formatting => Manage Rules =>
Current Selection.
There you can choose which rule should be deleted.

Dealing with CF's in Excel 2010 is a lot more awkward than in 2003, at
least for my purposes...

e.g. in 2003, if I had a group of cells that I wanted to delete just the
2nd CF from, I would Ctrl-click the cells, click delete, then it would
ask me which of the formats I wanted to delete. Then I would just tick
the 2nd condition & click OK.

In 2010 however, I cannot see a way of doing this without selecting each
of the cells one of the time & deleting the required format by hand?

 

[Vidcapper]

To me, this seems a lot more complicated than in Excel 2003 which I'm
used to?

In 2003, you just choose the cell(s), select Format-Conditional
Formatting, then away you go.

In 2010 though, while you can select multiple cells at once to view
their formatting, I can't see any way of, say, selecting formats in
multiple cells, then deleting them all at once?

Is there a way to do this, or do I have to go through a laborious 4 or 5
click method on every individual cell?

I hope this makes sense!

Following up again...

I can find no way of selecting one cell, editing/deleting one (of
several) formats in *just* that cell such that it doesn't affect
identical formatting in every other cell that shares the same
formatting. Is this even possible?

 

[ak440031]

Easy way to understand about formatting in excel
http://excelautomate.blogspot.in/2013/11/using-custom-format-for-numbers-dates.html

 

[Vidcapper]

Easy way to understand about formatting in excel
http://excelautomate.blogspot.in/2013/11/using-custom-format-for-numbers-dates.html

Unfortunately custom formatting doesn't provide what I need.

After much Googling & experimenting, the only way I can find to achieve
the individual cell conditional-format editing that I require, is to
save my spreadsheet in Excel 2003 format, and edit it on my old laptop
that still has that version on it.

Hardly an ideal long-term solution!

 

[GS]

Following up again...

I can find no way of selecting one cell, editing/deleting one (of
several) formats in *just* that cell such that it doesn't affect
identical formatting in every other cell that shares the same
formatting. Is this even possible?

Formatting applies only to the cell (or cells) selected at the time you
define the format. This is consistent in all versions of Excel, on all
platforms! The formatting applied to a single cell does not change any
other cells not selected at the time it's applied!!!

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion

 

[Vidcapper]

Formatting applies only to the cell (or cells) selected at the time you
define the format. This is consistent in all versions of Excel, on all
platforms! The formatting applied to a single cell does not change any
other cells not selected at the time it's applied!!!

Then the problem perhaps is that the same format was applied to a number
of cells at once (in Excel 2003), and now I've moved to 2010, I find
that any conditional format I try to alter for one of those
aforementioned cells, now affects all the others defined at the same time...

 

[GS]

Then the problem perhaps is that the same format was applied to a

number of cells at once (in Excel 2003), and now I've moved to 2010,
I find that any conditional format I try to alter for one of those
aforementioned cells, now affects all the others defined at the same
time...

I don't have 2010 installed but is there an option you can uncheck so
it doesn't affect all the other cells?

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion

 

[Vidcapper]

I don't have 2010 installed but is there an option you can uncheck so it
doesn't affect all the other cells?

I have no idea if there is - I've only just started using 2010.

 

[Claus Busch]

Hi Garry,

Am Wed, 04 Dec 2013 10:55:16 -0500 schrieb GS:

I don't have 2010 installed but is there an option you can uncheck so
it doesn't affect all the other cells?

it is the same as in xl2007. You can choose "Delete Rules in sheet" and
"Delete rules in selected cells".
Or you can choose "Manage Rules"and change there the range where the
rule is applied to.


Regards
Claus B.

 

[Vidcapper]

Hi Garry,

Am Wed, 04 Dec 2013 10:55:16 -0500 schrieb GS:


it is the same as in xl2007. You can choose "Delete Rules in sheet" and
"Delete rules in selected cells".

Or you can choose "Manage Rules"and change there the range where the
rule is applied to.

Unfortunately, for the number of formatted cells I have, it is
impractical to change them piecemeal.

 

[GS]

Hi Garry,

Am Wed, 04 Dec 2013 10:55:16 -0500 schrieb GS:


it is the same as in xl2007. You can choose "Delete Rules in sheet"
and "Delete rules in selected cells".
Or you can choose "Manage Rules"and change there the range where the
rule is applied to.


Regards
Claus B.

Thanks, Claus! That's good to know...! (I still develop/design in
2003<g>)

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion