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.

 

[Geek Girl 007]

Hi again Peter,
It's the text not background.
Column G Is a total of C to F

Am I making sense yet???
Sorry if I'm being confusing??

 

[Peter_SSs]

please list all the cell(s) that should be red in that sample.

I didn't get an answer to that but see if this is it

Select H10:H? and apply the CF shown.

22 05 24.xlsm
	A	B	C	D	E	F	G	H
1	CF	AM
2	18	19
3	17.6
4
5
6			AM
7			Attended	Acceptable	Unacceptable	Not Recorded	Total	Spaces Left
8
9	SUNDAY	27-Mar-22
10	MONDAY	28-Mar-22					0	19
11	TUESDAY	29-Mar-22				7	7	12
12	WEDNESDAY	30-Mar-22					0	19
13	THURSDAY	31-Mar-22					0	19
14	FRIDAY	01-Apr-22					0	19
CF

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
H10:H14	Expression	=AND(H10>=0,H10<$B$2)	text	NO

 

[Geek Girl 007]

I didn't get an answer to that but see if this is it

Select H10:H? and apply the CF shown.

22 05 24.xlsm
	A	B	C	D	E	F	G	H
1	CF	AM
2	18	19
3	17.6
4
5
6			AM
7			Attended	Acceptable	Unacceptable	Not Recorded	Total	Spaces Left
8
9	SUNDAY	27-Mar-22
10	MONDAY	28-Mar-22					0	19
11	TUESDAY	29-Mar-22				7	7	12
12	WEDNESDAY	30-Mar-22					0	19
13	THURSDAY	31-Mar-22					0	19
14	FRIDAY	01-Apr-22					0	19
CF

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
H10:H14	Expression	=AND(H10>=0,H10<$B$2)	text	NO

YEAY.
This worked, thank you so much.

 

[Peter_SSs]

Good news. Thanks for confirming.

 

[Geek Girl 007]

Good news. Thanks for confirming.

Sorry it took me so long, been a crazy week at work.

 

[Peter_SSs]

Sorry it took me so long, been a crazy week at work.

No problem. Hope this week is better.