conditional formatting

[emmykav]

Hello, I have data in two tables, and I need to apply conditional formatting where the data matches and where it differs. For example:

if I have a business that has 2 general managers and 3 assistant managers (table 1 - this data will change), and they should have 1 general manager and 5 assistant managers (table 2- this data will stay the same), I would like the number in table 1 to show red for example for the general manager, as there are too many, and assistant manager to go orange, as there are not enough.

Thank you!

 

[Joe4]

Duplicate: https://www.mrexcel.com/forum/excel-questions/1066977-conditional-formatting-formula.html

Please do not post the same question multiple times. All clarifications, follow-ups, and bumps should be posted back to the original thread. Per forum rules, posts of a duplicate nature will be locked or deleted (rule 12 here: Forum Rules).
If you do not receive a response, you can "bump" it by replying to it again, though we advise you to wait 24 hours before doing and not to bump a thread more than once a day.