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?
 

Some videos you may like

Excel Facts

Waterfall charts in Excel?
Office 365 customers have access to Waterfall charts since late 2016. They were added to Excel 2019.

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
 

Watch MrExcel Video

Forum statistics

Threads
1,122,719
Messages
5,597,741
Members
414,171
Latest member
12Rev79

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