Conditional Formatting Help

[Michael151]

Hello all,

Just need some help with conditional formatting. I'm trying to format column D so that if a cell in this column contains the word "OPEN" then it formats it to red, bold.

Help is appreciated - thank you!

 

[Marcelo Branco]

That's what I've been trying and it does not work.

I was wondering what I was doing wrong. I highlight column D, open condition formatting, Formula Is ="Open", then bold, red.

Does not format the cells.

Michael,

Try this
Use a formula to...(last option) and insert
=D1="Open"

It worked perfect for me

HTH

M.

 

[Marcelo Branco]

-edit-

=countif($b$1:$b$30,a1)

m.