Fill Color / Background change based on cell input

I have a work sheet that I created to allow different information to be displayed based on the selection made in one cell. I can select a number from 1 to 32 from a drop down cell in cell BH20 and it places information intered in other cells into the correct cells. If I select 3 from BH20 then it enters the next row of information and so on. I would like for the sheet to high light or change the fill color of the cells that are selected based on the selection in BH20. Is there formula simular to conditional formatting that can do this?

Example:
If BH20=2, then background color for BH26, BI26, BJ26, BK26 = yellow
If BH20=3, then background color for BH27, BI27, BJ27, BK27 = yellow
and so one with the standard background of fill being white or another color

According to your profile, your version of Excel is limited to a maximum of three conditional formats. If you have more than three conditions you will need to use VBA.

Get Around Excels 3 Criteria Limit in Conditional Formatting

Is there formula simular to conditional formatting that can do this?

What exactly is your question? Just use the Formula Is option for the cells you want to apply the CF to and use an absolute reference to cell BH20.

Formula for cells BH26, BI26, BJ26, BK26: =$BH$20 = 2
Formula for cells BH27, BI27, BJ27, BK27: =$BH$20 = 3

and set the fill color to yellow

Conditional Formatting Help

hi genderson

do you mean somthing like this ??

I'm not sure that I understand how this is done as to what is to be input in the cases.
This is my work sheet that I am trying to change the fill colors on.

I have attached the work sheet for you to review