Change the background colour of a row??

[Geek Girl 007]

Can I change the background of all the cells in this row if one of the cells has PH in it?
I was looking at Conditional Formatting because I already have SUM's etc in a couple of the cells.
Thank you in advance

 

[jtakw]

Hi,

If "PH" is in G4

Book3.xlsx
	A	B	C	D	E	F	G
1
2
3
4							PH
Sheet1041

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
A4:F4	Expression	=$G4="PH"	text	NO

 

[Geek Girl 007]

Hi jtakw,
It would seem like you're my saviour at the moment.
How do I set this? would it make a difference that the cell with PH (stands for Public holiday) might have different text in it?

 

[jtakw]

Hi jtakw,
It would seem like you're my saviour at the moment.
How do I set this? would it make a difference that the cell with PH (stands for Public holiday) might have different text in it?

Your pic did not show any Column or Row IDs, so will need that info.
By "different text", do you mean combined with PH, (e.g. ABC PH DEF), or just something else?
Give samples for clarification.

Consider using XL2BB to post samples (see my signature), or at least in Table format, for future reference.

 

[Geek Girl 007]

It's a drop down menu...

Column I has this formula in it =IF((F14-E14)+(H14-G14)=0,"",IF(H14-G14<0,"",(F14-E14)+(H14-G14)))
What odd with this formula is that when you fill out it doesn't work until i put the last number in:

I don't mind that it does this, just thought I'd mention it

 

[jtakw]

Ok.

Select E14:J18, starting at E14.
Home tab, Conditional Formatting, New Rule
Use formula
Enter formula exactly as shown
Format, pick your Fill color, OK.

Book3.xlsx
	E	F	G	H	I	J	K
14							PH
15
16
17
18							PH
Sheet1053

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
E14:J18	Expression	=$K14="PH"	text	NO

This will highlight E:J on any of the rows that has "PH" in column K.

 

[Geek Girl 007]

I'm so sorry, now I feel like i'm really dumb.
I'm stuck entering your formula here:

I'm so sorry, I am still learning, I downloaded XL2BB and will install it tonight.
Thank you

 

[jtakw]

In that Center box, that's where you enter the formula.
Then, lower right, click "Format"
Then, click the "Fill" tab on top Right
Choose your color, then click OK.

 

[Geek Girl 007]

This is what I did, but it didn't work
When I went into 'Manage Rules' this it what came up:

 

[jtakw]

No, enter Only the formula, like this:

=$K14="PH"

You'll now need to delete formatting from those cells, if any, and start again.