LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2
Default Reference of current cell

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.

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Nesting a sheet name reference within a cell reference??? Broyston Excel Discussion (Misc queries) 9 July 8th 08 08:35 PM
Help with this conditional IF statement C-Dawg Excel Discussion (Misc queries) 3 May 15th 06 06:01 PM
How to have a variable cell reference across sheets? Shane Gibson Excel Discussion (Misc queries) 3 March 8th 06 10:10 PM
Cell Reference locking Hysteresis Excel Discussion (Misc queries) 1 November 3rd 05 05:05 PM
how to create a variable column in cell reference Sampson Excel Worksheet Functions 3 February 21st 05 10:13 PM


All times are GMT +1. The time now is 11:49 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"