Home |
Search |
Today's Posts |
#1
|
|||
|
|||
to Dave Peterson
Dave,
it appears that when I reply to your posts that my email gets bumped and I get that mail deilivery subsytem message. Here were what came when I entered those functions, supplying the address of two separate but blank cells in the column. I get True in the first and 0 in the second Ross ----- Original Message ----- From: "Dave Peterson" Newsgroups: microsoft.public.excel.misc Sent: Saturday, September 17, 2005 6:59 PM Subject: Blank cell revisited |
#2
|
|||
|
|||
This is a followup to the question about using conditional formatting on column
J to indicate the empty cells. The two formulas were =isblank(J#) and =len(J#) for the cell that didn't get formatted correctly. I'm gonna guess that there was a mistake in the way Format|Conditional formatting was applied ('cause those results look ok). Select J1. Hit ctrl-spacebar Now hit format|conditional formatting. You should see Formula is: =J1="" and if you click on the format button, then pattern Tab|then select a nice fill color. Make sure you ok your way out. Most of this has already been posted, but double checking/redoing can't hurt. Ross wrote: Dave, it appears that when I reply to your posts that my email gets bumped and I get that mail deilivery subsytem message. Here were what came when I entered those functions, supplying the address of two separate but blank cells in the column. I get True in the first and 0 in the second Ross ----- Original Message ----- From: "Dave Peterson" Newsgroups: microsoft.public.excel.misc Sent: Saturday, September 17, 2005 6:59 PM Subject: Blank cell revisited -- Dave Peterson |
#3
|
|||
|
|||
Dave,
Yeah, that fixed it. What was in the box was this ="J1="" I had an extra quote in there somehow. My bad. :) Thanks a million for your help Ross "Dave Peterson" wrote in message ... This is a followup to the question about using conditional formatting on column J to indicate the empty cells. The two formulas were =isblank(J#) and =len(J#) for the cell that didn't get formatted correctly. I'm gonna guess that there was a mistake in the way Format|Conditional formatting was applied ('cause those results look ok). Select J1. Hit ctrl-spacebar Now hit format|conditional formatting. You should see Formula is: =J1="" and if you click on the format button, then pattern Tab|then select a nice fill color. Make sure you ok your way out. Most of this has already been posted, but double checking/redoing can't hurt. Ross wrote: Dave, it appears that when I reply to your posts that my email gets bumped and I get that mail deilivery subsytem message. Here were what came when I entered those functions, supplying the address of two separate but blank cells in the column. I get True in the first and 0 in the second Ross ----- Original Message ----- From: "Dave Peterson" Newsgroups: microsoft.public.excel.misc Sent: Saturday, September 17, 2005 6:59 PM Subject: Blank cell revisited -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Dave Peterson | Excel Discussion (Misc queries) | |||
Help from Dave Peterson - no disrespect to all other experts | Excel Discussion (Misc queries) | |||
Help from Dave Peterson - no disrespect to all other experts | Excel Discussion (Misc queries) | |||
UDF and Calculation tree | Links and Linking in Excel | |||
Attn: Dave P. Question re Pix Calls via Macro | Excel Discussion (Misc queries) |