Conditional Formatting Error

[Geek Girl 007]

I want to set the format for cell A3.
A2 has the format =B2-1 (equaling 18)

The end result I need is to colour format cell A3 if the number in it is between 0 and less then the number in cell B2.
I am clearly doing something wrong.

Thanks in advance.

 

[Marius44]

Hello
Try this formula in FC =E(A3>=0,A3<20)

Let me know. Hello,
Mario

 

[Geek Girl 007]

Hello
Try this formula in FC =E(A3>=0,A3<20)

Let me know. Hello,
Mario

No

 

[Marius44]

Hello
I don't know what to tell you: it works for me.
You have, by chance, the update in "Manual". If so, change it to "Automatic".
Hello,
Mario

 

[Peter_SSs]

Hello
Try this formula in FC =E(A3>=0,A3<20)

No

I think part of the problem is that Mario's formula is in Italian. Try this one

22 05 22.xlsm
	A	B
1
2		19
3	17
Sheet2

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
A3	Expression	=AND(A3>=0,A3<B2)	text	NO

 

[Geek Girl 007]

These are my settings.

 

[Geek Girl 007]

I also tried

&

Neither worked???

 

[Geek Girl 007]

I think part of the problem is that Mario's formula is in Italian. Try this one

22 05 22.xlsm
	A	B
1
2		19
3	17
Sheet2

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
A3	Expression	=AND(A2>=0,A2<B2)	text	NO

Hi Peter,
I totally missed your reply, thank you
I need it to only highlight if the number is 0 to 1 less than the number in cell B2, hence I put the formula:
=B2-1 in cell A2 and I'm using that...... however it still changes for to total in cell B2

 

[Peter_SSs]

Are you saying that my suggestion did not work for you?
If it didn't work, please provide an example of the values in B2 and A3
- where my suggestion did not format the cell when it should have, and/or
- where my suggestion did format the cell when it should not have.

 

[Geek Girl 007]

Hi there
B2 has just a number at the moment (19) but I'm hopeful in the future to link it to another sheet that is updated with any changes.
A3 is a sum to calculate an advantage. =SUM(H9:H15)/5

This is the formatting in A3 at the mo.