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

Create a Pivot Table on a Map
If your data has zip codes, postal codes, or city names, select the data and use Insert, 3D Map. (Found to right of chart icons).

Marcelo Branco

MrExcel MVP
Joined
Aug 23, 2010
Messages
17,024
Office Version
  1. 2019
  2. 2010
Platform
  1. Windows
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

Board Regular
Joined
Mar 10, 2011
Messages
70
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

Board Regular
Joined
Mar 10, 2011
Messages
70
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
 

Michael151

Board Regular
Joined
Sep 20, 2010
Messages
247

ADVERTISEMENT

Thanks Tigs81, that actually made everything red though..
 

Tigs81

Board Regular
Joined
Mar 10, 2011
Messages
70
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

Board Regular
Joined
Sep 20, 2010
Messages
247

ADVERTISEMENT

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

Board Regular
Joined
Mar 10, 2011
Messages
70
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

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

Board Regular
Joined
Mar 10, 2011
Messages
70
do not change it to "Formula Is"
Leave it as "Cell Value Is" and select equal to
 
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

Forum statistics

Threads
1,164,297
Messages
5,836,481
Members
430,434
Latest member
whatabout

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
Top