Home |
Search |
Today's Posts |
#4
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]() I'm trying to do exactly that--make it change cell color based on the calculated value, and have more than 3 conditions. Is there a modification to this that someone can suggest? Thanks in advance for any insight anyone can offer. Brian Chip Pearson Wrote: Note that Bob's code will run only when the cell's value is changed by the user, not, as is the case with Conditional Formatting, when the change is the result of a calculation. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com -- bkcoughlin ------------------------------------------------------------------------ bkcoughlin's Profile: http://www.excelforum.com/member.php...o&userid=32284 View this thread: http://www.excelforum.com/showthread...hreadid=507761 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
More than 3 Conditional Formatting Conditions | Excel Worksheet Functions | |||
Conditional formatting capability for 20+ conditions not just 3. | Excel Discussion (Misc queries) | |||
Additional Conditions for Conditional Formatting | Excel Worksheet Functions | |||
Conditional formatting: I have five conditions, how to do this? | Excel Discussion (Misc queries) | |||
Adding more than three Conditions to 'Conditional Formatting' | Excel Discussion (Misc queries) |