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]

Hi,

Select the entire Column D

CF > New Rule > Use a Formula to..
=D1="OPEN"
Format button and pick the format you want

HTH

M.

 

[Tigs81]

Hi

You would hightlight column d and open the conditional formatting window
Change criteria to cell value is equal to ="Open"
Click on the Format Button and select the Pattern Tab, Click on Red
Select the font tab and click on bold
Ok and Ok.

Thanks
Tigs

 

[Tigs81]

Sorry miss read the question

You would hightlight column d and open the conditional formatting window
Change criteria to formula is

=IF(COUNTIF($D:$D,"Open")>0,TRUE,FALSE)

Click on the Format Button and select the Pattern Tab, Click on Red
Select the font tab and click on bold
Ok and Ok.

Thanks
Tigs

 

[Michael151]

Thanks Tigs81, that actually made everything red though..

 

[Tigs81]

Michael

Marcelo Branco and my first option would highlight only the cells that have "Open" in it. So that might do the job that you are after all.

When i re read your msg it sounded to me like you wanted to hightlight the whole column.

Hope this helps

Thanks
Tigs

 

[Michael151]

Sorry if my original post was confusing.

Yes, I have a column of about a 1000 rows. Highlighting individual cells would take quite a while. I'd like to somehow apply conditional formatting to column D so that any cell in column D that reads "OPEN" is highlighted in bold, red:

ColumnD
text
text
OPEN
text
OPEN
text
text

 

[Tigs81]

then

You would hightlight all column d and open the conditional formatting window
Change criteria to cell value is equal to ="Open"
Click on the Format Button and select the Pattern Tab, Click on Red
Select the font tab and click on bold
Ok and Ok.

thats would do the job

Thanks
Tigs

 

[Michael151]

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.

 

[Tigs81]

do not change it to "Formula Is"
Leave it as "Cell Value Is" and select equal to