Clueless with Conditional Formatting

[BixWhetter]

Evening! (or morning to some of you!)

I'm new to the site but have heard good things so I'm hoping someone can help me.

I've put a spreadsheet together designed for multiple people to update/add to on a regular basis. When a line is complete a number is put into a specific cell (e.g. Z3), when this value is added I need to make the whole row (e.g. Row 3) green. I cannot for my life work out the formula for this!! I've got as far as being able to fill just the cell, not the whole row...

Any advise is much appreciated! Thanks in advance!
Bix

 

[Momentman]

WELCOME TO THE FORUM

Do you always know what row it is?

If you do, simply Highlight the whole row and use a formula like $Z$3 = 1 for example