• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

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

mitz123

New Member
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.
 

Attachments

  • Sushmita_Requirement.xlsx
    10.1 KB · Views: 9
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,
 
Back
Top