Simple Conditional Format solution, hopefully???

[Taff]

If cell AJ4 is between 3.9% and 12.9% I want cell O4 to be coloured green.

Struggling to get the simplicity of it, any pointers appreciated.

 

[Joe4]

Enter the following CF formula on cell O4:

=AND(AJ4>=3.9%,AJ4<=12.9%)

 

[Scott T]

With AJ4 selected
In Conditional formatting select Highlight cell rules
then select between
Then enter your lower and upper values 3.9% and 12.9
Select your formatting
Select OK

 

[Joe4]

With AJ4 selected
In Conditional formatting select Highlight cell rules
then select between
Then enter your lower and upper values 3.9% and 12.9
Select your formatting
Select OK

That will format cell AJ4. They want to format cell O4 (based on the value in AJ4).

 

[Taff]

Cheers guys, very much appreciated

Taff