Formatting a Row Question

[Bryan]

Is it possible to conditionally format an entire row based
on input into one cell in that row, or am I "rowing"
upstream?

All help on this appreciated,

Bryan

 

[Max]

Yes, perhaps a simple example to illustrate ..

Select row1 (click on the row header)

Click Format >Conditional Formatting

Under Condition 1, make the settings:
Formula Is | =$B1=1
Click Format button > Patterns tab > gray > OK

Click OK at the main dialog

Now key in a "1" into B1, press Enter
Row1 will be coloured gray

Clear B1, the colour disappears

(Note that the $ sign in the formula is important)

 

[Bryan]

Hi Max,

That's close to what I was looking for. Problem is I'd
like the row to format the color in regardless of what is
entered in the cell. Specifically, there will be dates
entered in that cell and they will, of course, vary.

Thanks for the quick reply,

Bryan

 

[Bryan]

Hi Again Max,

I figured it out. Used <>0 instead of the =1, works just
like I wanted it to.

Thanks for getting me on the right track.

Have a great day,

Bryan

 

[Max]

Glad to hear that, Bryan !
Thanks for the feedback