Conditional formatting Help

[welshman010]

I try to create a rule that if any cells from M6:AV42 match cells in C6:C30 they will highlight yellow. Any help much appreciated.

Thanks

[tuph]

Please attach a copy of your workbook so we can test solutions on your data. Remember to remove/replace any sensitive data before uploading.

[welshman010]

Example attached. Keys would be entered in range A3:A41. If i entered a key on rota and matched key in Range A3:A41 key on rota would highlight yellow

[Malkier]

welshman010,

Does the attached meet your needs?
Conditional formatting on second sheet...

Formatting ExampleSheet_Malkier.xlsx

[sktneer]

Try this formula to make a new rule for conditional formatting for the range M6:AV42

Please Login or Register  to view this content.

[welshman010]

Try this formula to make a new rule for conditional formatting for the range M6:AV42

Please Login or Register  to view this content.

Thanks. Perfect

[sktneer]

Glad I could help. Thanks for the feedback.
If that takes care of your question, please mark your thread as solved by selecting Thread Tools --> Mark thread as solved.
Moreover you may also click on * (star) to Add Reputation to those who have put their time and efforts to help you in this forum. This is another way to say thanks to them.

[Malkier]

welshman010,

Did you open the spreadsheet that I edited for you?