|
|
#9
09-25-2018, 04:09 AM
|
|||
|
|||
Quote:
I defined a block of 3 numbers and assigned the named range MyNumbers to it. In those cells I typed in 1, 1, and 1. As an example, I used in CF >> =SUM(MyNumbers)=3 Works okay for me. 
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
 looking to change cell color by typing number into the cell
|
ibs | Word Tables | 1 | 11-22-2016 06:31 PM |
|
Entering a number in a cell causes it to fill with the color of a nearby cell
|
Bill Martz | Excel | 1 | 04-23-2015 07:57 PM |
|
Cell Background Color: Base it on Content of Cell?
|
tatihulot | Excel | 4 | 08-14-2013 03:24 PM |
| How can I fill cell color starting from Cell D5 using Conditional formatting instead | Learner7 | Excel | 0 | 07-08-2010 05:50 AM |
| How can I make a cell color RED under the Today's date cell? | Learner7 | Excel | 2 | 07-08-2010 12:52 AM |
Windows Vista 
Office 2007
Threaded Mode