Conditional formatting - Range of cells

erutherford

Active Member
Joined
Dec 19, 2016
Messages
462
Can conditional formatting format a range of cells? I can only get it to do one cell.

This is what I tired, but excel only formats the first cell cell. =B2="55mm"+$E$10:$H$26

Didn't think it would be that hard to find, but I know I'll find it here

thank you for your time
 
Yes, this can be done.

What you should do is select the entire range you want to apply the Conditional Formatting rule to first.
Then, go to Conditional Formatting, select the Formula option, and write your Conditional Formatting formula as it applies to the first cell in your selected range.
Excel will automatically adjust the formula for all the other cells in your range.
Bear in mind that if you do not want any row or column references to "float" (change as the range changes), you will need to put a "$" in front of them in order to lock them down.
 
Upvote 0
Yes excel did exactly as you said.
Selected the range
select the first cell in the range: $E$26
excel did adjust the range : =$E$26:$H$42

But no formatting occurred.
 
Upvote 0
No, that is not what I said to do at all.

You select the whole entire range at the beginning (E26:H42).
Then go to Conditional Formatting and select the Formula option (precisely, "Use a formula to determine which cells to format").
Then type in your formula as it pertains to cell E26, and Excel will adjust it for all the other cells in your pre-selected range.
 
Upvote 0
If you are having trouble getting it to work, please post a sample of your data and expected result, and we can probably help you out.
 
Upvote 0
I did get the issue solved. Its my formula that was the problem (I think). I used a simple =if true statement and it functioned fine. Joe4 thanks for the other requirements needed to complete this. Long day fishing on this one!
 
Upvote 0
Good to hear you found a solution.
If you would like to post the actual solution then it is perfectly fine to mark your post as the solution to help future readers. Otherwise, please do not mark a post that doesn't contain a solution.
 
Upvote 0
I followed "Joe4"'s instructions, but changed my formula from "$B$2="50mm" to =IF($B$2="50mm",TRUE,FALSE). It worked as I wanted. I am sure there are other ways, but this worked perfect.
 
Upvote 0
Solution

Forum statistics

Threads
1,226,812
Messages
6,193,114
Members
453,777
Latest member
Miceal Powell

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