Conditional Formatting Method-Colouring cell that contain text based on numeric values from another cell

[mitz123]

Hi ,
I am having an issue with one of my official work documents that requires me to highlight benchmark specific Names of Employee branch wise who fall under those benchmarks based on their vintage (No of Months in current Financial Year worked). Have attached the excel file with the output template please help me with this.

 

[Khalid NGO]

Hi,

You can do it with Conditional Formatting with following steps:

Select your range you want to highlight (J3:J28 or J3:M28)
Go to Home Tab
Conditional Formatting
Formula:

=AND($D3>=1,$D3<=3)
Format to Red Color and press OK

Same steps for remaining conditions
=AND($D3>=4,$D3<=7)
format to Amber

=$D3>=8
Format to Green

Regards,