Conditional formatting - Range of cells

[erutherford]

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

 

[Joe4]

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.

 

[erutherford]

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.

 

[Joe4]

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.

 

[Joe4]

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.

 

[erutherford]

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!

 

[Peter_SSs]

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.

 

[erutherford]

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.

 

[Peter_SSs]

Thanks for clarifying. If that worked for you in Conditional Formatting, then so would this simpler one as it will return the same TRUE/FALSE results without the need for the IF function.
=$B$2="50mm"