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

Dynamic coloring of text boxes

V

Villalobos

Active Member
Hello,

I would like to ask some help regarding dynamic text box coloring. I have some boxes which are part of a continuously changing dashboard, my target is that if a value is higher than the compared value then the color of is turning to red if it is lower then the color of text is turning to green.

The sample file is attached.

Do you have any idea how to do it?



Thank you!
 

Attachments

  • Text box coloring.xlsx
    10.9 KB · Views: 3
Hi ,

If you use the Camera tool , you can use Conditional Formatting to colour the cells according to the rules you have mentioned , and the picture will automatically reflect the colour of the cells.

See your file now.

Narayan
 

Attachments

  • Text box coloring.xlsx
    15.3 KB · Views: 13
Last edited:
You must log in or register to reply here.
Back
Top