Font change depending on result

  • Hi


    If I have a cell, A3, containing the formula '=A1+A2', is it possible to make the font of the cell change colour if the answer is negative?


    ie. if A1+A2 = +5 then A3 will display '5' in black ink
    if A1+A2 = -5 then A3 will display '5' in red ink


    Many thanks


    Johno

  • Re: Font change depending on result


    hi....


    try this....


    Select Cells from Format menu
    Choose Number tab
    From Category... select Number or Currrency
    On Negative numbers... select the last option (negative in red color/parenthesis)
    Check 1000 separator (,), if u wish



    OR


    Select Cells from Format menu
    Choose Number tab
    From Category... select Custom
    On Type:, write on the space provided:


    _(* #,##0.00_);[RED]_(* (#,##0.00);_(* "-"??_);_(@_)



    Note: You can change [Red] with other color e.g. [Blue] or [Green]


    For detailed explaination of Custom Number Format, go here:


    http://www.ozgrid.com/Excel/excel-custom-number-formats.htm

Participate now!

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