• 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.

Auto conversion in to colours

Browny Boxer

New Member
Hi

I am Ganesh Manchi from Chennai. My question is when I type in A1 as Yellow, I need a formula in B1 so that B1 gets filled with YELLOW colour, similarly for Green as GREEN colour. How do I do?

This I require my team to fill in their activities list about the status of each activity which is divided into GREEN - COMPLETED; YELLOW - WIP; BLUE - SUPPORT NEEDED; RED - CHALLENGE etc.

Thanks in advance for helping out.

Ganesh Manchi
 
Here you go... Look at the Conditional Formatting and Data Validation...

Respectfully,
PaulF
 

Attachments

  • Chandoo_CF.xlsx
    8.5 KB · Views: 5
Capture_zps1oiql62b.jpg
 
Thanks Paul, I got it and appreciate your response. It works well. Its so simple too.

Was under the impression that I had to write a lengthy formula ???

Thanks again,

Ganesh Manchi
 
Back
Top