Results 1 to 2 of 2

Thread: Color-fill conditional based on existence of data

  1. #1
    holo man
    Guest holo man's Avatar

    Color-fill conditional based on existence of data



    Register for a FREE account, and/
    or Log in to avoid these ads!

    Let say, there is a teble, and there are some resulting fields to show the results. There is need to change the color of field if the result number is greater than 2500. So how to write the codes to do so.

    Thanks to all,

    Asad

  2. #2
    Hello, you can use the Conditional Formatting tool, you create a rule that compares your data and format the cell. You can use fill options, or letter style options, etc.
    Microsoft Excel Massive Open Online Course.
    Learn all about Microsoft excel in this Online course, with video tutorials, examples of applications and a complete functions and buttons explanation.
    Be part of our community and enjoy learning Excel.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •