change cell colour

  • Morning all ..


    Am after the code to change a cell colour if the value is a minus figure.


    There is a formular within the cell that can either equate to an positive or negative figure .. and would like the cell changed to RED if the figure returns a negative answer.


    Thanks
    Tayler

  • Re: change cell colour


    Tayler, Lenze


    Conditional formatting will work, sure, but I think the usual Formatting of the cell is better. (although I'm not fully sure)


    Click on the cells, choose Cell formatting, and apply the custom format as in attachment.


    Wigi

  • Re: change cell colour



    You are of course correct for this particular scenario, provided the OP is only concerned with font color. For background color, CF is needed.;)


    lenze

  • Re: change cell colour


    Quote from lenze

    You are of course correct for this particular scenario, provided the OP is only concerned with font color. For background color, CF is needed.;)


    lenze


    Indeed Lenze

    Regards,


    Wigi


    Excel MVP 2011-2014


    For more Excel memes: visit http://www.wimgielis.com ==> English articles ==> Excel memes


    -- Topics without [CODE] tags or a meaningful topic title, will be neglected by me (and probably many others as well) --

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!