Conditional Formatting Need

[franco]

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

 

[franco]

I figured this out.
Thanks anyway.

 

[Ken Johnson]

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

 

[Ken Johnson]

I figured this out.
Thanks anyway.

Hi Franco,

You figured it out just as I posted.

Do we agree?

Ken Johnson

 

[franco]

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

 

[Ken Johnson]

Hi Frank,

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

Ken Johnson