#1
|
|||
|
|||
Conditional formatting
if a3 is < 100 then a4=10.00 otherwise show 0.00 Pieces Under $100 Over $100 $10.00 $0.00 $10.00 $0.00 $10.00 $0.00 $10.00 $0.00 |
#2
|
||||
|
||||
Hello to you too
Could you be a little more explicit please, my crystal ball is not working From what I understand =IF(A3<100,10,0) placed in A4 ?
__________________
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 |
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Conditional formatting | bbutl027 | Excel | 15 | 12-05-2016 08:56 PM |
Conditional Formatting | sdfrance | Excel | 3 | 01-06-2015 07:10 AM |
Conditional formatting that ignores other formatting rules | info_guy2 | Excel | 1 | 07-03-2014 10:07 AM |
conditional formatting | otuatail | Excel | 1 | 06-06-2012 05:07 AM |
Conditional Formatting | namedujour | Excel | 3 | 08-25-2011 01:46 PM |