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

 

[Geek Girl 007]

Thank you
That totally worked, I will totally give you credit when I give this new timesheet to my team in the morning.

 

[jtakw]

You're very welcome, thanks for the feedback.

Post a new thread whenever you have another question.

 

[Geek Girl 007]

Ok, I have one last one, but i'm gonna create a new thread for it cause i think that's the process.

 

[jtakw]

If it's not related to the topic of this thread, then that's a good idea.

 

[Geek Girl 007]

Hi Again,
I tried to do the same for the row of colour for cell L14 with this code.
=$L14="07:24"
But as you can see it didn't work.
I can't understand what I am doing wrong???

 

[jtakw]

As this is a different question (value wise), you probably should start a new thread.

But this is what you need, Assuming there's NO seconds value in L14:

=$L14=TIME(7,24,0)

 

[Geek Girl 007]

So sorry, I thought it was the same thread.

I will be more mindful in future.
I found a different 'workaround' but I;m guessing yours is WAY better.
I will add it and see,
Thank you (as always)

 

[jtakw]

Please, no apology needed, I was just thinking may be you may have more questions regarding the Time format in that cell, as Time is actually numbers, the way you had tried ="07:24", is looking for a Text value.

 

[Geek Girl 007]

It's defo a learning process
Thank you,
It totally worked....
I've finally finished the Timesheet.....
Onward to the next project ?