Conditional Formatting Help

F

Frank Kabel

Hi Lauren

not much detail but if you want to format cell A1 if it's
between B1 and C1 enter the following formula in the
conditional format dialog:
=(A1>B1)*(A1<C1)

Frank
-----Original Message-----
I'm looking for help with creating conditional formatting
Click to expand...
that is based on the values of 2 cells whose values change
all the time. I'm looking to set up the conditions for
ranges of numbers, say any amount between 100 and 200 but
to no avail. Any advice would be greatly appreciated!!
 
L

Lauren A

Thank you for your quick reply. Sorry for the lack of details. I'm not even sure if I asked it the correct way...What I am trying to do is this: I have two cells that will determine what size widget our customer will need to order. The first cell can either be a "1" or a "3". The second cell is based on a calculation and can range anywhere from 0-400 (the first cell is used in this computation). Within the spreadsheet I have a list of stock widget sizes and would like the correct size to automatically change color when all of the data is entered so as to not tax the brains of the salespeople. I thought conditional formatting would be a good option but I am having issues. Even with two conditions I can't seem to get it to work smoothly. It will change colors based on the "1" or "3" but not the second cell or vice versa

I am using a formula of "=A1=1" and "=A1=3" is the appropriate size cells as the first condition and have tried numerous formulae for 25-60, 61-80 etc. as the second condition

Hope this helps you help me!

Thanks so much!!
Lauren
 
D

Dave Peterson

I think you'll need to give some more info:

What are the stock widget sizes for 1? And what are the stock widget sizes for
3?

You could use a formula like:

=and(a1=1,a2<60)

But I'm sure it's not this simple.
 
Top