How can I highlite an entire row using conditional formatting?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I would like to have one cell I can enter an "X" into that would highlite the
entire row. I dont know if I have to use conditional formatting or if I have
to use a macro, but I am just needing a little guidance. Thanks.
 
Hi,

Select your row then

Format|conditional formatting, select formula is

paste this in
=$A1="x"
Choose a colour.


An X in a1 now shades the whole row.

Mike
 
Wow....You know sometimes you think about something so hard you dont see the
obvious. ;-) Thanks Mike.
 
Select the entire row or range of cells in that row then Format>CF>Formula is:
=$C1="x"

Format to a pattern and OK

If you select several rows you can do them all at once with the above.

Note the absolute reference to Column C($) and the relative reference to row 1


Gord Dibben MS Excel MVP
 
Back
Top