fill all cells in row with one cell entry
 

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.

fill all cells in row with one cell entry
 

"jv4_2+1" wrote:
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.

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 ..
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---

fill all cells in row with one cell entry
 

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

http://office.microsoft.com/en-us/as...929431033.aspx

http://office.microsoft.com/en-us/as...116611033.aspx

If above links broken, try the following.

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

Epinn

"jv4_2+1" wrote in message ...
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.