conditional formatting formula

plost33

Well-known Member
Joined
Oct 2, 2008
Messages
866
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
 
Upvote 0
i am confused. how do i select range a10:d300 and then still have active cell *** d10??
 
Upvote 0
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...
 
Upvote 0
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
 
Upvote 0

Forum statistics

Threads
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.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

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

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

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
Back
Top