Please Help, I really tried on my own.

Column A and Column B

If the cell value in column A1 is <6 format should be Blank
If it is 6.0-6.99 then it will look to B1 for more info
If it is 7-0-7.99 then it will look to B1 for more info
And if it is 8 or greater it will look to B1 for more info

If A1’s value is 6 or greater it is possible it will still remai
blank, but now it will look to B1 for that value, to determine wha
should happen with A1

If B1 is greater than 2.99 then A1 will remain blank and also B1 wil
be blank
If B1 is between 2.0 and 2.99 and A1 is between 6 and 7.99 the
formatting in both cells should be background color let’s say lit
green

If B1 is between 0 and 1.99 AND A1 is between 6 and 7.99 the
formatting in both cells should be background color lets say Dar
green

If B1 is 0-2.99 and A1 is 8 or greater they should both be Dark green.
If B1 is 3 or greater it doesn’t matter, both are blank.

I feel like this should be able to get done, but I’m having troubl
with getting the formula

--
franc
-----------------------------------------------------------------------
franco's Profile: http://www.excelforum.com/member.php...fo&userid=3682
View this thread: http://www.excelforum.com/showthread.php?threadid=56855

I figured this out.
Thanks anyway.


--
franco
------------------------------------------------------------------------
franco's Profile: http://www.excelforum.com/member.php...o&userid=36823
View this thread: http://www.excelforum.com/showthread...hreadid=568558

Hi Franco,

Light green...

=AND($B1>=2,$B1<=2.99,$A1>=6,$A1<8)

Dark green...

=OR(AND($A1>=6,$A1<8,$B1>=0,$B1<=2),AND($A1>=8,$B1<=2.99))

Same formulas for both A1 and B1.

Ken Johnson

franco wrote:
> I figured this out.
> Thanks anyway.


Hi Franco,

You figured it out just as I posted.

Do we agree?

Ken Johnson

Oh geez, I was afraid of that, that's why I posted that I had complete
it.
I woke up with it on my mind.

Yes we agree.

Thank you so much for taking the time out for it.

I really appreciate that.

Fran

--
franc
-----------------------------------------------------------------------
franco's Profile: http://www.excelforum.com/member.php...fo&userid=3682
View this thread: http://www.excelforum.com/showthread.php?threadid=56855

Hi Frank,

No worries, it's nice to know I got it right>

Ken Johnson