Is there any way of flagging blank cells within a spreadsheet?

Normally when one of the cells within any one row is populated, there are
additional cells in that same row that also needs to be populated in order
for the calculations/formulas on subsequent worksheets to work.

For example if one of these cells - X4, AL4, AZ4, BN4, CB4, CP4, DD4, DR4 -
is populated, I'd like some sort of flag to ensure that the remaining cells
in this range are also populated.

Any ideas?

Thanks in advance

I should also mention that once the cells mentioned have been populated, the
following range cells would then need to be monitored - Y4, AM4, BA4,BO4,
CC4, CQ4, DE4 and DS4.

"Sarah (OGI)" wrote:

> Is there any way of flagging blank cells within a spreadsheet?
>
> Normally when one of the cells within any one row is populated, there are
> additional cells in that same row that also needs to be populated in order
> for the calculations/formulas on subsequent worksheets to work.
>
> For example if one of these cells - X4, AL4, AZ4, BN4, CB4, CP4, DD4, DR4 -
> is populated, I'd like some sort of flag to ensure that the remaining cells
> in this range are also populated.
>
> Any ideas?
>
> Thanks in advance

Sarah,
select all cells needed to be flagged..
can u accept a conditional formatting to flag your attention on blank cells ?
then let's try on cell A1 : format>cond.format...>formula is> =
A1=""....then format>pattern> then pick ur flag color....

regards,
driller
*****
birds of the same feather flock together..



"Sarah (OGI)" wrote:

> I should also mention that once the cells mentioned have been populated, the
> following range cells would then need to be monitored - Y4, AM4, BA4,BO4,
> CC4, CQ4, DE4 and DS4.
>
> "Sarah (OGI)" wrote:
>
> > Is there any way of flagging blank cells within a spreadsheet?
> >
> > Normally when one of the cells within any one row is populated, there are
> > additional cells in that same row that also needs to be populated in order
> > for the calculations/formulas on subsequent worksheets to work.
> >
> > For example if one of these cells - X4, AL4, AZ4, BN4, CB4, CP4, DD4, DR4 -
> > is populated, I'd like some sort of flag to ensure that the remaining cells
> > in this range are also populated.
> >
> > Any ideas?
> >
> > Thanks in advance

Assuming you are not using xl2007

Select the range of cells. You can select separate cells by holding down
Ctrl whil clicking on the cells. I'd then make a range name by clicking on
the name box to the left of the formula toolbar. Call it something like
KeyCells. then you can click on the Name Box and select KeyCells and the
range will than be selected. You can press the TAB key to move through each
cell in the range.

To show blank cells Visually, use Conditional Formatting. If you have
created the range name click on the Name Box and select the range or go
through the process above.
With the range selected Choose Format, Conditional Format. Set condition1 to
Cell Value is, in the next Tab choose "is equal to" from the drop down
list. In the third box type "="" " without the first and last quotes. Click
the Format Button, choose Patterns Tab and select a colour then exit the form
clicking OK as you go.

Blank cell in the range Key cells will have the background colour until you
enter some data.

Regards
Peter

"Sarah (OGI)" wrote:

> I should also mention that once the cells mentioned have been populated, the
> following range cells would then need to be monitored - Y4, AM4, BA4,BO4,
> CC4, CQ4, DE4 and DS4.
>
> "Sarah (OGI)" wrote:
>
> > Is there any way of flagging blank cells within a spreadsheet?
> >
> > Normally when one of the cells within any one row is populated, there are
> > additional cells in that same row that also needs to be populated in order
> > for the calculations/formulas on subsequent worksheets to work.
> >
> > For example if one of these cells - X4, AL4, AZ4, BN4, CB4, CP4, DD4, DR4 -
> > is populated, I'd like some sort of flag to ensure that the remaining cells
> > in this range are also populated.
> >
> > Any ideas?
> >
> > Thanks in advance