Select all of row 1 then open the Format, Conditional Formatting dialog.
Change the "Cell value is" to "Formula is" and paste in this formula:

=MAX(COUNTIF(1:1,1:1))1

and then set the format you want when this formula is true.

--
Jim Rech
Excel MVP
"havocdragon" wrote in message
...
| Hello all. So here are 2 things I am trying to do.
|
| I would like to make a worksheet function or process, that will change an
| entire row green when 2 values in that row match. For instance K1 cell
value
| is 1 and R1 cell value is 1, the line would turn green, if it was a 0 in
R1
| then nothing would happen. Heres the catch though, I want that to happen
in
| real time. So when I type 1 and hit enter, the line would turn green.
|
| Heres the second thing I want to do!
| I would like to make some check boxes, that when checked will turn a line
| red (or another color). I would also like to do this for several lines,
maybe
| 200, once the macro is made for that, is there a way to attach it to its
| specific cell, without having to retype a macro 200 times?
|
| Thanks in advance