Formatting a Row Question

  • Thread starter Thread starter Bryan
  • Start date Start date
B

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
 
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)
 
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
 
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
 
Back
Top