DippNCope
Board Regular
- Joined
- May 21, 2009
- Messages
- 77
hello I am an excel noob as this question will show
Here is my situation; I have a worksheet that work orders are entered on sheet 1, in column N.is the date last modified. Daily the number of orders changes from 10 to 100. On sheet2 I pull only three of the columns including column N and then do conditional format to change the color to red dates that are older then today. Since I do not know how many there will be in column N I put ="sheet1"!N1 and did that to N100 but the blank ones show as 1/0/00 and I would like to know how to leave it blank if it is blank on sheet1.
Thanks in advance,
DippNCope
Here is my situation; I have a worksheet that work orders are entered on sheet 1, in column N.is the date last modified. Daily the number of orders changes from 10 to 100. On sheet2 I pull only three of the columns including column N and then do conditional format to change the color to red dates that are older then today. Since I do not know how many there will be in column N I put ="sheet1"!N1 and did that to N100 but the blank ones show as 1/0/00 and I would like to know how to leave it blank if it is blank on sheet1.
Thanks in advance,
DippNCope