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....



    SUPER FRUSTRATING.


    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!