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

    Tayler [the blue fox] :thanx:

  • 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

    Files

    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) --

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