Whole row conditional formatting

I need to highlight the whole row in a table when a cell in a column (say column G) has an entry in it.

Any ideas?

Thank you in advance.
Farah MohammedBuyerAsked:
Who is Participating?
 
jppintoConnect With a Mentor Commented:
See attachements...it's OK now?
Book1-2-.xlsx
Capture.JPG
0
 
barry houdiniCommented:
any entry?

The trick is to use $ in front of the column reference, e.g. if your table is in A2:J20 then select that whole range and then use the formula that would apply to the first row,

=$G2<>""

that;s for any entry. For s specific value like 2 or "x" change to

=$G2-"x"

or

=$G2=2

regards, barry
0
Cloud Class® Course: Microsoft Azure 2017

Azure has a changed a lot since it was originally introduce by adding new services and features. Do you know everything you need to about Azure? This course will teach you about the Azure App Service, monitoring and application insights, DevOps, and Team Services.

 
barry houdiniCommented:
See attached example

barry
26846267.xlsx
0
 
Farah MohammedBuyerAuthor Commented:
Tried all your advices, but what am I doing wrong (see attached)?
Book1.xlsx
0
 
jppintoCommented:
You're not applying to the entire range! See image. That's what you need to put.

jppinto
Capture.JPG
0
 
jppintoCommented:
This is what you had...
Capture.JPG
0
 
Farah MohammedBuyerAuthor Commented:
That kind of worked over the rows... but I show some highlighted and some not and some are highlighted wrongly. All I did was change the range it applied to.

Thank you for your patience....
Book1.xlsx
0
 
Farah MohammedBuyerAuthor Commented:
I copied your "formulas" above (see attached pic) but it still shows the same.... highlighting some and not highlighting others, etc.... (like the spreadsheet I sent earlier, which is the exact copy of the spreadsheet I use).


Pic-1.docx
0
 
barry houdiniConnect With a Mentor Commented:
Do you need condition 2? That appears to have an error in it - perhaps you should delete that altogether.

The essential rule for your other condition - the formula should refer to the first row of the range, so if the range starts at row 5 (as it does) then the formula should refer to G5.......alternatively if the formula refers to G2 (as it does) then the range should start at row 2

regards, barry
0
 
Farah MohammedBuyerAuthor Commented:
Barry - you are right. I realised where my error was.
jppinto - I realised what you were showing me. Thank you so much for your patience in walking this through with me.
0
 
SANTABABYCommented:
squirrelzan,
When I opened(in excel 2003) your latest worksheet, the conditional format formuale appeared to be incorrect. Please see the attached file:

Xl0000018.xls
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.