Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Cells showing unwanted information...
I am setting up a control sheet for monitoring visits. I have it set that
when you put in a consumer's start date, it automatically fills in the date the first visit should be made and so on. My problem is that if I leave a space blank, it fills in a date from 1900. I know I can use conditional formatting or something to solve this, I just can't figure it out. Can someone please help? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Cells showing unwanted information...
I assume you have soemthing like:
column A Column B Row 1 Start Date 1st Visit Row 2 1/1/2007 4/1/2007 and B2 has a formula like =A2+90 or some such. and if you leaveA3 blank, you get a value in B3. solution. change B2 to: =if(A2="","",A2+90) or whatever your original formula was... This will leave a blank in the B cells for missing A cells. "artemis1027" wrote: I am setting up a control sheet for monitoring visits. I have it set that when you put in a consumer's start date, it automatically fills in the date the first visit should be made and so on. My problem is that if I leave a space blank, it fills in a date from 1900. I know I can use conditional formatting or something to solve this, I just can't figure it out. Can someone please help? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how to add values of cells only if a corresponding cell has information on it | Excel Discussion (Misc queries) | |||
a function that counts the number of cells with information | Excel Worksheet Functions | |||
a function that counts the amount of cells with information in them | Excel Discussion (Misc queries) | |||
Not Printing the information in cells | Excel Discussion (Misc queries) | |||
filling information in cells | Excel Discussion (Misc queries) |