Reference of current cell

[miguel.guerreiro]

I have a document that requires the conditional formating of several
hundred cells which are spreadout across the document. I would like to
know if the is a function or a method that I can use to assign a
general function to all of these cells at the same time without having
to modify the argument of this function for each of the cells.

Example: I want to change the font to green in all these afected cells
if there is an error in that specific cell. So I would be doing a
Conditional Formating using the "Formula Is" =ISERR(C15) where C15 is
just one of these cells.

I want to replace C15 (the cell reference) by some expression that
returns C15 when that "current cell" is executing the =ISERR() formula.
This way, I can apply the conditional formatting to all the affected
cells at the same time without having to change the cell address for
any of them individually!

Can this be done? How?

Thanks.

 

[Guest]

I think you could make it using the CELL function without any reference.
=CELL("address") returns the address of the last modified cell...
Come back if necessary!

 

[RagDyeR]

After you format C15 to your liking,

*Double* click the "Format Painter" icon (yellow paint brush) on the
toolbar,
Then simply click in *each* of the cells that you wish to have this same
format.

When finished, hit <Esc> to exit the format duplicating procedure.

--

HTH,

RD
=====================================================
Please keep all correspondence within the Group, so all may benefit!
=====================================================

I have a document that requires the conditional formating of several
hundred cells which are spreadout across the document. I would like to
know if the is a function or a method that I can use to assign a
general function to all of these cells at the same time without having
to modify the argument of this function for each of the cells.

Example: I want to change the font to green in all these afected cells
if there is an error in that specific cell. So I would be doing a
Conditional Formating using the "Formula Is" =ISERR(C15) where C15 is
just one of these cells.

I want to replace C15 (the cell reference) by some expression that
returns C15 when that "current cell" is executing the =ISERR() formula.
This way, I can apply the conditional formatting to all the affected
cells at the same time without having to change the cell address for
any of them individually!

Can this be done? How?

Thanks.

 

[miguel.guerreiro]

Thanks people. Your help was great. The CELL("address") did not work
well inside the ISERR() function, but the Format Painter solution
worked great. The formula in the C15 cell (=ISERR(C15) was copied by
the painter to all the other cells, and the painter inserted the
address of each of these cells individually in the ISERR formula
argument.

I couldn't believe it. It was so easy.

Thanks for the knowledge guys.

 

[Ragdyer]

Appreciate the feed-back.