Hello there,
This should be something ease but for some reason it's not working. In my spreadsheet i have two sheets, Sheet1 where i want the rows to highlight and Sheet2 where i created a tag name ( list ) called "test".
I'm using conditional formatting to do that, it works only when i type a word in the cell, when i put a number, which is what i want, it doesn't work.
in conditional formatting i tried ="test" ; =$A1="test" and nothing seems to work, the only time that it worked was when i changed to =$A1="b", and then i typed "b" in the cell and it worked.
What am i doing wrong?
This should be something ease but for some reason it's not working. In my spreadsheet i have two sheets, Sheet1 where i want the rows to highlight and Sheet2 where i created a tag name ( list ) called "test".
I'm using conditional formatting to do that, it works only when i type a word in the cell, when i put a number, which is what i want, it doesn't work.
in conditional formatting i tried ="test" ; =$A1="test" and nothing seems to work, the only time that it worked was when i changed to =$A1="b", and then i typed "b" in the cell and it worked.
What am i doing wrong?