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

Select all contiguous cells
Pressing Ctrl+* (asterisk) will select the "current region" - all contiguous cells in all directions.

lenze

Legend
Joined
Feb 18, 2002
Messages
13,690
Select D10:D300 with D10 as the Active cell.
Use CF>Formula Is
Code:
=(D10>30)*(D10<61)
Select a background color

lenze
 

plost33

Well-known Member
Joined
Oct 2, 2008
Messages
866
i am confused. how do i select range a10:d300 and then still have active cell *** d10??
 

plost33

Well-known Member
Joined
Oct 2, 2008
Messages
866
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

Legend
Joined
Feb 18, 2002
Messages
13,690
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
 
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

Forum statistics

Threads
1,163,879
Messages
5,834,208
Members
430,263
Latest member
abz54

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
Top