Forum Discussion
Solved
Conditional Formatting using both current and adjacent cells
Apologies if this is a duplicate - my previous attempt didn't seem to post properly. Hello! I am trying to format a column of cells based on both the number contained within the cells to be f...
Hi Clare,
I didn't check the logic of your function, just to mention what Excel adds extra quotations since you use incorrect syntaxis for the formula, thus Excel considered it as text.
AND and OR are functions, not operators. Correct syntaxis will be =AND(a,b) not =(a AND b)
Hi Clare,
I didn't check the logic of your function, just to mention what Excel adds extra quotations since you use incorrect syntaxis for the formula, thus Excel considered it as text.
AND and OR are functions, not operators. Correct syntaxis will be =AND(a,b) not =(a AND b)
Thanks Sergei - all fixed now, much appreciated :)