Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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". |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
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) |