Hi!
I am stuck on making this formula for conditional formatting to work:
=AND(search("Buymaxx*",B:B),COUNTIFS(F:F,"=891",F:F,"=7410",F:F,"=318",F:F,"=277",F:F,"=983",F:F,"=386",F:F,"=522",F:F,"=802",F:F,"=895 (buffer truck)")>1)
EDIT: I also tried this formula but to no avail =AND(search("Buymaxx",B:B),COUNTIF(F:F,F:F)>1)
Basically, I want the sheet to highlight cells in column F that has different plate numbers (the numbers on the formula) if column B contains the word "Buymaxx". I am trying this on google sheets but I think it is still appropriate to post this on this forum. I hope you can help me on this.
Thanks in advance!
Ian
Bookmarks