Do you need each row triggered by the occurrence of a blank in the E cell for that row? If so, try the following condional format:
Use Formula Is and set it to =ISBLANK($E2) for cell A2, set the formatting as desired. Then copy the formatting to A2:L500. This should grey out each cell from A to L when E is blank on a particular row.
As I was awaiting a response - I performed the test on a brand new sheet and got good results.
I believe the sheet that was sent to me had other format limitations upon it - that was keeping it from colorizing properly.
* I created the new sheet within the same file,
* Left row 1 for headers....
* Highlighted the blank row 2 ..... A2:Q2
* Conditionally format: =ISBLANK($E2)
* Copied the row down through row 600 ( which made the whole page "grey" )
* Went to the original sheet full of data, highlighted all
* Went to new sheet, EDIT > Paste Special > VALUES
and everything lit up beautifully with the appropriate rows GREY and all others left white....
THANKS for the help though! -- this ISBLANK for the range works perfectly on a clean sheet.
Sorry, I didnt read the post properly. Are you saying for instance if cell E1 is blank then format all of row 1 in your selection or if E1 is not blank then do not format the row?
This means every cell in the row will within your selection will look at the corresponding value of E & row and if blank will apply formatting. Because the row is relative (hasnt got the absolute $ sign) then this should work.