Conditional formatting using name ranges and formulas

Hi all,

Is it possible in the example attached (without using VBA), to enter a formula into the conditional formatting box for cell B13?

All I need it to do is to format blue fill if ID 1-5 is selected, and orange if ID 6-10 is selected. This is just a mock up of a bigger example using multiple name ranges across many worksheets, so I'm trying to understand how this works (if at all).

I've named the ranges "blue" and "orange" as per the fill used.

I want to say "If B13 = 'blue' named range, then fill blue" but I'm not sure if that's possible via a conditional formatting formula?

Thanks....

Got the solution..

check the attachment..


Don't forget to click *

explanation...

first select A13 to E13

then add conditional formatting
with formulas..

Formula:

Please Login or Register  to view this content.

2nd condition..

Formula:

Please Login or Register  to view this content.

Don't forget to click *

Thank you for your reply.

This has worked for this example, however I am looking for a solution using name ranges in the formula, as I need to expand this on a larger scale over several worksheets.

I think I just need to tweak it to include the blue and orange name ranges, but I don't know how to correctly enter the formula.

Thanks...

Thanks again, however the 2 conditions this are based on are using the numbers 1-5, and 6-10.

I need the condition to be set dependant on the name ranges blue and orange, is this possible?