Conditional formating based on cell value

Please check the attachment.

In REVENUES > Conditional Formatting :

I want to turn grey the text of all rows where the Column M = "received" or "canceled"

but problem is that there is another value "to receive" that get mixed by Excel with "receive" as the later is contained by the former

Anyone can help me fix a formula for this conditional formating?

Thanks
Simon

Select cells from row 3 down and use:

Formula:

Please Login or Register  to view this content.

=OR($M1="received",$M1="canceled")
will do it

I noted the spelling of canceled is with a single L
also you selected the range from row 1 - so formula needs to have row1

you need to select the area you want the formatting to apply to

so if you select A3 to Z100 for example
then the formula needs to start at row 3
if you select A2 to Z100
then the formula starts at row 2

So if you select the sheet


REVENUES!$B$2:$N$10485762
then as your selection starts in row 2 - B2

Then the formula
=OR($M2="received",$M2="cancelled")

i notice the cancelled now has 2 L's

you are welcome

Ditto. You're welcome.