conditional formatting formula

[plost33]

I am wanting to put a formula in for conditional formatting. the formula should change the background color to red if the value in D10:D300 is between 31 and 60.

i am using the formula below and it is not working:

=COUNTIFS($D$10:$D$300,">30",$D$10:$D$300,"<61")


anyone know why?

 

[lenze]

Select D10:D300 with D10 as the Active cell.
Use CF>Formula Is

=(D10>30)*(D10<61)

Select a background color

lenze

 

[plost33]

i am confused. how do i select range a10:d300 and then still have active cell *** d10??

 

[plost33]

i figuered out the other one was not working because it was generating a number and not true or false. i am now using:


=ISLOGICAL(COUNTIFS($D$10:$D$300,">30",$D$10:$D$300,"<61"))

this gives me true or false, but it seems to not work either...

 

[lenze]

i am confused. how do i select range a10:d300 and then still have active cell *** d10??

Select cell D10 and drag down to D300. D10 will remain the active cell. Another way, is to just select D10 and apply the formatting. Then use the Formatting PaintBrush to copy the formatting to the rest of the cells(D11:D300)
lenze