# conditional formatting formula

#### plost33

##### Well-known Member
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?

### Excel Facts

Round to nearest half hour?
Use =MROUND(A2,"0:30") to round to nearest half hour. Use =CEILING(A2,"0:30") to round to next half hour.
Select D10:D300 with D10 as the Active cell.
Use CF>Formula Is
Code:
``=(D10>30)*(D10<61)``
Select a background color

lenze

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

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...

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

Replies
10
Views
508
Replies
2
Views
147
Replies
4
Views
180
Replies
6
Views
149
Replies
2
Views
478

1,214,437
Messages
6,119,520
Members
448,903
Latest member
StephMJ

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back