conditional format based on another cell value

[The Grim Discovery]

People

I want D9 to grey if the value in D8 is anything other than "Other"

I'm entering this formula into the use a formula function of Conditional Formatting

=if($D$8<>"Other")

And it's not having it. Please help.

Lots of thanks

 

[BenGee]

Try this instead..

=IF($D$8<>"Other",TRUE,FALSE)

 

[philwojo]

Or try just

=$d$8<>"other"

 

[Joe4]

As philwojo's response shows, it is not necessary to wrap it an in IF statement.
The use of <> or = results in boolean results, by default.

If you had multiple conditions to check, you can simply use AND or OR, which also results in boolean values, i.e.
=AND(condition1, condition2)

 

[The Grim Discovery]

Thanks Ben, Phil and Joe - your guidance and time is appreciated