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
hkwebproductions
hkwebproductions asked in Computers & InternetSoftware · 1 decade ago

Cell color in Excel, conditional formatting?

How do I change the cell color in excel? Not so fast, I know the easy way. If A2=Joan Smith, and B2 has a "P" for paid, I want to make A2 cell color turn green. I am already using conditional formatting to change B2 to green as soon as I enter a "P" for paid. How do I get A2 to match B2? And should I toss in an R2D2 as well? jk.

2 Answers

Relevance
  • Michael B
    Lv 6
    1 decade ago
    Favorite Answer

    Conditionally format cell A2 as follows:

    Formula Is

    =(B2)="P"

    Then set cell color condition to green as you did with B2.

    Leave R2D2 alone; he's been through enough already!

    Source(s): Me. Excel whizkid
  • Cozmosis
    Lv 7
    1 decade ago

    Put thia as the conditional format formula for A2

    Formula is =B2="P"

Still have questions? Get your answers by asking now.