fill all cells in row with one cell entry

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

Guest

I have a range of cells and in that range If I enter any type of text/number
I want the rest of the row that cell belongs to, to be blacked out or marked
somehow to show that, that row has an entry in it already. Is this possible.
Please help. thank you.
 
jv4_2+1 said:
I have a range of cells and in that range If I enter any type of
text/number
I want the rest of the row that cell belongs to, to be blacked out or
marked
somehow to show that, that row has an entry in it already. Is this
possible.
Click to expand...

Assume range is A1:D5

Select A1:D5 (with A1 active)
Click Format > Conditional Formatting

Under Condition 1, make the setting as:
Formula is:
=SUMPRODUCT(--MATCH(TRUE,$A1:$D1<>"",0))<>COLUMN(A1)
Click "Format" > Patterns tab > Black > OK
Click OK at the main dialog

Test it out ..

---
 
Would you like to check out conditional formatting. Wonder if this is what you need.

http://office.microsoft.com/en-us/assistance/HA010929431033.aspx

http://office.microsoft.com/en-us/assistance/HA011116611033.aspx

If above links broken, try the following.

http://tinyurl.com/nhba5
http://tinyurl.com/rbqah

Epinn

I have a range of cells and in that range If I enter any type of text/number
I want the rest of the row that cell belongs to, to be blacked out or marked
somehow to show that, that row has an entry in it already. Is this possible.
Please help. thank you.
 
Back
Top