Adjacent Column Conditional Formatting error

  • Hi All,

    Driving me crazy this..but I've got a bunch of cells in Column O called "Manually Update"

    I want the adjacent column in G to highlight a colour when "Manually Update" is found.

    So I picked formula under conditional formating and wrote after selecting all of Column G:

    =O2 = "Manually Update"

    But it seems to highlight only a few examples and not all....


    Any ideas?

  • Re: Adjacent Column Conditional Formatting not working on every cell!

    if you are select column G and then doing condition formatting, you will need to change the formula to =O1 = "Manually Update"

Participate now!

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