Cell Row Formatting

  • Hi, I posted b4 to no avail. Maybe I wasnt clear hehe :)

    Ok simple thing is:

    I have this in the ThisWorkbook module:

    Now what I want is if the any cell in Column A is "(None)" then make it yellow
    any cell in column B make it white

    so some sort of case like:

    Case "(None)": .Interior.ColorIndex = 36

Participate now!

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