Conditional Formatting Question

[pfdizzy]

Hi

A follow on from my Bingo Card question really.

I want to create a worksheet so that what items are called then the item on the Bingo Card is automatically highlighted. This would allow quick checking against all issued cards. I have so far managed to create a drop-down list for easy selection but the drop down is not really large enough so how can I increase the size of it.

File attached

Thanks in advance

Pfdizzy

[FlameRetired]

Select C2:F30, click HOME > Conditional Formatting > New rule > Use formula to determine which cells to format.

Then use this formula.

Please Login or Register  to view this content.

Apply the formatting you like and click OK all the way back out.

[pfdizzy]

Thank you for your help

[FlameRetired]

You are welcome. Thank you for the feedback.