Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Nesting a sheet name reference within a cell reference??? | Excel Discussion (Misc queries) | |||
Help with this conditional IF statement | Excel Discussion (Misc queries) | |||
How to have a variable cell reference across sheets? | Excel Discussion (Misc queries) | |||
Cell Reference locking | Excel Discussion (Misc queries) | |||
how to create a variable column in cell reference | Excel Worksheet Functions |