Conditional Formatting doesnt allow me to write the equal symbol for a formula

Hello,

 

That warning is just telling the formula is not complete. If you finish typing the formula and get it correct and closed the warning will go away. Until you completely close the formula with the last parenthesis ) that warning will show.

 

Hope this helps,

Stephen

But I could find a way to do it for matching to values in the same row.

I mean, it working without the = sign but I need to change the structure.

Now I need to know how to write a formula without using the equal sign, something that I've never did in my live.

Any clue?

Hello Diego Alonso de Maria,

 

The "Invalid Formula" warning is just a warning. Once the formula is competed and closed with the final parenthesis ) the warning will go away. My guess is you are missing a parenthesis somewhere in your formula.

 

If that doesn't work or you still need more help with this I suggest that you share an editable COPY of your sheet. Use your sample sheet to demonstrate what you'd like the sheet to do!  Here are some tips to help you get a great answer quickly... Product Experts TIPS FOR SHARING  

 

Tip: Read the Tips post above, then check your sharing settings before posting - you want "Anyone with the link can Edit"  

 

Stephen

Hi Diego,

 

You're in great hands with Stephen trying to help you, but you seem to be struggling with some of the mechanics. 

 

There is no Custom Formula without a leading = symbol. That's a dead end you should stop trying to go down.

 

And now you're having a problem with a CountIF(). 

 

If you want to solve these problems and learn more about Sheets, help Stephen to help you by sharing a copy of your sheet. That is the most productive and easiest way to get the answers you need.

 

I solved the problem with the count if by creating a new spreadsheet in which I am the owner and everything runs OK.

So what is explained in this link (below) is not valid anymore in google sheets?

Thanks

Hello,

 

The link you have posted is trying to explain that in the case of IF() which needs a specified out come for at least a TRUE you can simply use =A2="Yay" instead of =IF(A2="Yay",True,False) within that link you will also see where it states that all custom formulas start with an equals sign.