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!
 

Some videos you may like

Excel Facts

Do you hate GETPIVOTDATA?
Prevent GETPIVOTDATA. Select inside a PivotTable. In the Analyze tab of the ribbon, open the dropown next to Options and turn it off

Marcelo Branco

MrExcel MVP
Joined
Aug 23, 2010
Messages
16,393
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
 

Watch MrExcel Video

Forum statistics

Threads
1,109,362
Messages
5,528,258
Members
409,811
Latest member
pjwhyman

This Week's Hot Topics

  • Change military grades into rank
    Afternoon all Need help with formula that will change military rank (i.e. 1, 2, 3 into Amn, A1C, SrA). Running IF formula that does not work...
  • VBA COUNTIF SOLUTION
    Hi The following are the errors spread across the several columns from E to Q ie. 13 columns across several sheets with more than 500 rows per...
  • INSERT ROW WITH SPECIFIS TEXT IN A COLUMN
    Hi All! How can identify that that the row to be inserted has to be inserted before 1st row with specific text in column F. If I record the...
  • Auto-Create a monthly Sign in sheet for preschool students
    The image below is what each page looks like. Above is space for the "Child Name" "Month" "Class" School days are obviously Monday-Friday but...
  • VBA vlookup multiple results
    Hi folks, Hopefully someone out there can help. I have a list to vlookup which works (ish). the lookup only picks up the first instance of the...
  • Extract values for earliest/latest times
    I am trying to put together a formula to get the earliest start time, the latest end time from column A for each person in Column B-F without the...
Top