identifying blank cells

stef in chi town

New Member
Joined
Jan 25, 2005
Messages
4
I work with a series of spreadsheets that quite often need inserted rows and I need to make sure those inserted rows have specific columns copy the formula of the cells above.

Either that or have a conditional format in a designated cell that can scan a series of cells and alert me when one is blank.

I am hoping to make this function automatic with no macros to run.

Can someone please help? I'm going bananas.
 

Excel Facts

Formula for Yesterday
Name Manager, New Name. Yesterday =TODAY()-1. OK. Then, use =YESTERDAY in any cell. Tomorrow could be =TODAY()+1.

RalphA

Well-known Member
Joined
May 14, 2003
Messages
3,829
Maybe this can help you:

In A1:A4, I entered data.
In B1, I entered the formula, =countblank(A1:A4)
In B1, I entered the Conditional Formatting, =(countblamk), then selected Format, Patterns, and selected a background color (red, in my case).

Now, I went to row 4, and entered a new row 4. Cell B1 turned red, and showed the number of blanks as 1.

I went to new row 5, and entered a new row 5. Cell B1 remained red, and showed the number of blanks as 2.

Perhaps you can adapt the idea to your particular problem?
 

HalfAce

MrExcel MVP
Joined
Apr 6, 2003
Messages
9,456
Hi Stef, welcome to the board.

When you say "no macros to run" do mean no macros at all, or just ones that have to be manually executed?

I would think if you have any specific criteria for adding rows that would always apply, we could use a macro to add the row(s) and fill the desired cell(s) with your formula at the same time.

If this is undesirable, then Ralph's soultion might be just the ticket.
(That's a great idea Ralph!)

Dan
 

Forum statistics

Threads
1,148,220
Messages
5,745,456
Members
423,952
Latest member
EduardoM

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top