Highlight row

  • Thread starter Thread starter dave
  • Start date Start date
D

dave

Hello,

My doing some inputting work where it contains lots of data. So I need
help to find a VB formula. So once I done the row I want to entire row
to be highlighted. For example Im retrieving data from A1:H1 and once
this done I want to mark I1 with D (Done). So when I type D in I1 I
want A1:H1 to be highlighted.

Appreciate your help

Thank you
 
Hello,

My doing some inputting work where it contains lots of data. So I need
help to find a VB formula. So once I done the row I want to entire row
to be highlighted. For example Im retrieving data from A1:H1 and once
this done I want to mark I1 with D (Done). So when I type D in I1 I
want A1:H1 to be highlighted.

Appreciate your help

Thank you
Click to expand...

You can do that with conditional formatting (unless you really want
VBA) xt
 
You can do that with conditional formatting (unless you really want
VBA) xt
Click to expand...

Hello,

I have tried in conditional format but its only highlight one cell.
When I entered D in H1, only cell A1 get highlighted but I want all
the cell from A1 to G1 to be get highlighted. Any suggestion?

Thanks
 
Hi Dave,

Am Fri, 7 Oct 2011 13:02:44 -0700 (PDT) schrieb dave:
I have tried in conditional format but its only highlight one cell.
When I entered D in H1, only cell A1 get highlighted but I want all
the cell from A1 to G1 to be get highlighted. Any suggestion?
Click to expand...

select A1:G1 => conditional format => formula:
=$H1="D"


Regards
Claus Busch
 
Back
Top