Ashhu
Active Member
I have Engineer Skill table. In Col A i have engineers Name and in Row 2 i have skills required.
For each engineer there is Required skill level and Actual Skill level rating given , from 1 to 5.
Help:
If Required skill is greater than Actual skill, then actual cell should highlight. this helps to plan training.
Ex: C5 cell highlighted because Eng2 actual skill is not matching with required.
I have list 50+ engineers and 10+ skills , Can it be done using conditional formatting.
For each engineer there is Required skill level and Actual Skill level rating given , from 1 to 5.
Help:
If Required skill is greater than Actual skill, then actual cell should highlight. this helps to plan training.
Ex: C5 cell highlighted because Eng2 actual skill is not matching with required.
I have list 50+ engineers and 10+ skills , Can it be done using conditional formatting.