Yahoo Answers is shutting down on May 4th, 2021 (Eastern Time) and beginning April 20th, 2021 (Eastern Time) the Yahoo Answers website will be in read-only mode. There will be no changes to other Yahoo properties or services, or your Yahoo account. You can find more information about the Yahoo Answers shutdown and how to download your data on this help page.

Trending News

Promoted
ANISE
Lv 4
ANISE asked in Computers & InternetSoftware · 1 decade ago

Can I use conditional formatting on this formula - I want it to look red if the words "OUT OF BALANCE" appear

=+IF(L6=(M6+N6),"OK","OUT OF BALANCE")

How would I do it.

I will vote for 10 points for the best answer.

Thank-you

Update:

I am using Microsoft Excel

2 Answers

Relevance
  • FireBath
    1 decade ago
    Favorite Answer

    You don't need the formula just select the whole column and ad a conditional formating for result = 'OUT OF BALANCE' and Excel will color in red everything on that column that has OUT OF... written in it as a result. So if your formula returns this result it will be colored in red. You can ad other colors as well for different results of the same formula.

  • bigtalltom
    Lv 6
    1 decade ago

    Office 2007 has this functionality.

    I think for previous versions of office you'll need to write a macro.

Still have questions? Get your answers by asking now.