I have a sheet where I need to highlight cells in column Y based on a word being present in column G and the value of Y being greater than 0.2
I tried using =AND(G2:G1048576="Draw",Y2:Y1048576>0.2) but it generates an error
What is the correct syntax for what I want?
It is basically column G from row 2 showing the word Draw and column Y from row 2 being greater than 0.2
Thanks in advance
I tried using =AND(G2:G1048576="Draw",Y2:Y1048576>0.2) but it generates an error
What is the correct syntax for what I want?
It is basically column G from row 2 showing the word Draw and column Y from row 2 being greater than 0.2
Thanks in advance