none
EXCEL FORMULA TO HIGHLIGHT ANOTHER A CELL IF THE VALUE OF ANOTHER CELL BE MORE THAN 2 VALUES RRS feed

  • Question

  • PLEASE HELP ME OUT

    I NEED A EXCEL FORMULA SUCH AS

    CHECK THE VALUE OF A1

    IF VALUE OF A1 = 'PIPE' OR 'FLANGE'  THEN WILL HIGHLIGHT THE COLUMN B1 TO GREEN

    IF VALUE OF A2 = 'PIPE' OR 'FLANGE'  THEN WILL HIGHLIGHT THE COLUMN B2 TO GREEN

    IF VALUE OF A3 = 'PIPE' OR 'FLANGE'  THEN WILL HIGHLIGHT THE COLUMN B3 TO GREEN

    .

    .

    .

    IF VALUE OF A10 = 'PIPE' OR 'FLANGE'  THEN WILL HIGHLIGHT THE COLUMN B10 TO GREEN

    • Edited by maya456 Thursday, March 28, 2013 7:20 AM
    Thursday, March 28, 2013 7:01 AM

Answers

  • Use Conditional Formatting with formula

    like this example:

    Try build formula by your self, do ya?


    Oskar Shon, Office System MVP

    Press if Helpful; Answer when a problem solved

    Thursday, March 28, 2013 8:26 AM
    Answerer