"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
---