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
Billy
Billy asked in Computers & InternetProgramming & Design · 1 decade ago

What is the Formula to Highlight specific Cells is another cell = specific text?

Im using Excel 2007 and I have a spread sheet that cells A1,A2,A3,A4,A5,A6 need to be filled red if Cell A7 = Y. How can I do this? I have experimented with the conditional formatting for a while but can't figure it out. Please help.

1 Answer

Relevance
  • voyager
    Lv 6
    1 decade ago
    Favorite Answer

    Select A1:A6

    Click Conditional Formatting on the Home tab

    Click New Rule

    Click "Use a formula to determine which cells to format"

    Enter =$A$7="Y"

    Click Format

    On the Fill tab, choose a color (red)

    Click OK, OK, Apply

Still have questions? Get your answers by asking now.