CODEWITHSUNDEEP
google-sheetsformulags-conditional-formatting
I.hope
I.hope

Reputation: 73

How to reference cells in a conditional formatting formula rule?

I wold like to use the value of the current cell into to "Custom formula is.." when using conditional formatting.

I would like to enter a "Custom formula", which will check if value of cell is ether'a' or 'b'.

What will be correct syntax?

Upvotes: 1

Views: 1945

Answers (1)

pnuts
pnuts

Reputation: 59485

Please try:

Select the range the conditional formatting is to apply to, say C5:C10. Format, Conditional formatting…, Add new rule, Format cells if…, Custom formula is: 

=or(c5="a",c5="b")

Select your Formatting style (Default may suit) and Done.

Upvotes: 2

Related Questions