| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
custom function with conditional formatting?
I already know how to do conditional formatting.
"Karin" wrote: Format Conditional Formatting If you need to see if column B is equal to column A, and mark column Bi if is NOT equal, then: in B1 (if data begins there) do conditional formatting as follows and then copy to entire column Cell Value Is Not Equal to A1 and change format to anything you like (red font or red background, etc) "Steve" wrote: I often have to test a large number of cells to see if they're equal. I usually use a-b or =a=b and check if the answer is either zero or true. If not I know they're not equal. It would be nice if I could do this with a custom formula that would also turn the background red, for example, if the answer isn't either zero or true. I doubt this can be accomplished with a custom formula, though, since formulas are meant to return values, not "do something". |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| 2003: Having trouble with conditional formatting with custom user function (Repost) | Excel Worksheet Functions | |||
| Conditional Formatting and IF function help | Excel Discussion (Misc queries) | |||
| Conditional Formatting - Applying Format Based Custom Functions | Excel Discussion (Misc queries) | |||
| Conditional formatting on a function | Excel Discussion (Misc queries) | |||
| Custom function for Sum Product (Conditional Formula) | Excel Discussion (Misc queries) | |||
Hybrid Mode
