Alert icon
We're changing our privacy policy. This stuff matters.  Learn more  Dismiss

Excel: Change the color of a cell based on a certain condition

Loading...

Sign in or sign up now!
Alert icon
Upgrade to the latest Flash Player for improved playback performance. Upgrade now or more info.
6,400
Loading...
Alert icon
Sign in or sign up now!
Alert icon

Uploaded by on Nov 14, 2010

This video will explain how to change the font based on a certain condition.

Category:

Entertainment

Tags:

License:

Standard YouTube License

  • likes, 0 dislikes

Link to this comment:

Share to:

Uploader Comments (everydayexcelstuff)

  • Hello,

    Sorry for taking so long to answer.  I have to admit that I do not know. I don't use charts a lot. Sorry.

  • Hello. I'm not sure I understand what you are asking. Are you wanting to know if B8 can be colored red if it totals to 0?

    Regards,

    Stacy.

  • Hello,

    It should work the same way if you choose to format using the font color. Let me know if I can help.

see all

All Comments (9)

Sign In or Sign Up now to post a comment!
  • is it possible to color the cell with a condition that will be met ? suppose i have a distances chart, and when i key in two cities, he distance in the chart can color up ? possible ?

  • "Sales Ass" ;)

  • Hey can you help me? Lets use your example as mine.

    If B8 gets 0, A2-C8 cells become red color(eventhough C column is empty). Is it possible?

    Thanks

  • THANK YOU VERY MUCH FOR THAT.... very good tut. keep up the good work.

  • thanks for this

Loading...

Alert icon
0 / 00Unsaved Playlist Return to active list
    1. Your queue is empty. Add videos to your queue using this button:
      or sign in to load a different list.
    Loading...Loading...Saving...
    • Clear all videos from this list
    • Learn more