Conditional Formatting Help

Michael151

Board Regular
Joined
Sep 20, 2010
Messages
247
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!
 

Excel Facts

Round to nearest half hour?
Use =MROUND(A2,"0:30") to round to nearest half hour. Use =CEILING(A2,"0:30") to round to next half hour.
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.
 
Upvote 0
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
 
Upvote 0
Sorry miss read the question

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

Code:
=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
 
Upvote 0
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
 
Upvote 0
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
 
Upvote 0
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
 
Upvote 0
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.
 
Upvote 0

Forum statistics

Threads
1,216,102
Messages
6,128,853
Members
449,471
Latest member
lachbee

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top