|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Why am I unable to click and drag a simple formula using conditional formatting?
1. A1=10, A2=20, A3=30...A10=100
2. C1=5 3. In column B I want to multiply each number in column A by C1 4. In B1 I enter "=A1*$C$1" 5. In B1 "30" appears as expected. But when I click and drag the fill handle to B2-B10, "30" also appears in all those cells as if I had copied the formula without conditionally formatting C1. This has worked as it should in the past, so I am not sure what is wrong. I am using Excel 2016 in Windows 10. I tried the same thing in another workbook without luck. Anyone able to tell me what might be wrong? Thanks! |
#2
|
|||
|
|||
Is calculation set to manual?
|
#3
|
||||
|
||||
Quote:
If A1 is 10 and C1 is 5, A1*C1 should be 50 not 30???
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Conditional formatting not working with simple formula | bendmc | Excel | 2 | 11-17-2016 11:31 AM |
Need conditional formatting formula | namedujour | Excel | 1 | 05-27-2016 08:58 AM |
Conditional Formatting Formula | teza2k06 | Excel | 1 | 08-22-2014 02:49 AM |
Formula/Conditional Formatting | teza2k06 | Excel | 1 | 04-15-2014 06:49 PM |
conditional formatting formula | NEHicks503 | Excel | 1 | 11-30-2011 09:01 AM |