I have a huge list of arrival dates of transport trucks into Receiving (Col.
M in the sample below). Each truck has skids and skids of orders, which are
all listed row by row (thus, you see a repeat of the arrival date because
each row is a different order, but on the same truck). I have columns
calculating the transit time, one which includes weekends & holidays (COL.
O), and another excluding these days (COL. P). In column R and S I want to
show only once the transit time of columns O and P on the first row of the
arrival of that truck (there is another formula in the worksheet based on the
numbers in columns R and S, which value would be greatly distorted if these
numbers repeated for every row, therefore I cannot use the transit time
numbers in columns O and P). For a particular reason, I colour the cells in
columns R and S yellow which contain the values from O and P, which I put in
manually. However, I would like to simply colour the cells yellow and they
would know then to take the values from Col. O and P and plug them in,
without me having to also type them in manually. But if this is a
complicated affair, doing it manually may be the way to go. Scroll down.....
COL. L COL. M COL. N COL. O COL. P COL. Q
COL. R COL. S
Jul-06-05 Jul-11-05 (5) 5 3 Trans X 5 3
Jul-20-05 Jul-11-05 9 5 3 Trans X
Jul-20-05 Jul-11-05 9 5 3 Trans X
Jul-20-05 Jul-11-05 9 5 3 Trans X
Jul-19-05 Jul-11-05 8 5 3 Trans X
Jul-19-05 Jul-11-05 8 5 3 Trans X
Jul-19-05 Jul-11-05 8 5 3 Trans X
Jul-19-05 Jul-11-05 8 5 3 Trans X
Jul-19-05 Jul-11-05 8 5 3 Trans X
Jul-08-05 Jul-11-05 (3) 5 3 Trans X
Jul-15-05 Jul-11-05 4 5 3 Trans X
Jul-15-05 Jul-11-05 4 5 3 Trans X
Jul-14-05 Jul-11-05 3 5 3 Trans X
Jul-14-05 Jul-11-05 3 5 3 Trans X
Jul-06-05 Jul-11-05 (5) 5 3 Trans X
Jul-13-05 Jul-11-05 2 5 3 Trans X
Jul-14-05 Jul-12-05 2 5 3 Trans X 5 3
Jul-21-05 Jul-12-05 9 5 3 Trans X
Jul-20-05 Jul-12-05 8 5 3 Trans X
Jul-20-05 Jul-12-05 8 5 3 Trans X
Jun-20-05 Jul-12-05 (22) 5 3 Trans X
Jul-19-05 Jul-12-05 7 5 3 Trans X
Jul-19-05 Jul-12-05 7 5 3 Trans X
Jul-19-05 Jul-12-05 7 5 3 Trans X
Jul-19-05 Jul-12-05 7 5 3 Trans X
Jul-19-05 Jul-12-05 7 5 3 Trans X
Jul-08-05 Jul-12-05 (4) 5 3 Trans X
Jul-14-05 Jul-12-05 2 5 3 Trans X
Jul-25-05 Jul-15-05 10 3 3 Trans X 3 3
Jul-28-05 Jul-15-05 13 3 3 Trans X
Jul-21-05 Jul-15-05 6 3 3 Trans X
Jul-27-05 Jul-15-05 12 3 3 Trans X
Jul-27-05 Jul-15-05 12 3 3 Trans X
Jul-26-05 Jul-15-05 11 3 3 Trans X
Jul-26-05 Jul-15-05 11 3 3 Trans X
Jul-26-05 Jul-15-05 11 3 3 Trans X
Jul-19-05 Jul-15-05 4 3 3 Trans X
Jul-18-05 Jul-15-05 3 3 3 Trans X
Jul-15-05 Jul-15-05 0 3 3 Trans X
Jul-27-05 Jul-19-05 8 5 3 Trans X 5 3
Aug-02-05 Jul-19-05 14 5 3 Trans X
Aug-02-05 Jul-19-05 14 5 3 Trans X
Aug-02-05 Jul-19-05 14 5 3 Trans X
Jul-29-05 Jul-19-05 10 5 3 Trans X
Jul-28-05 Jul-19-05 9 5 3 Trans X
Jul-21-05 Jul-19-05 2 5 3 Trans X
Jul-28-05 Jul-19-05 9 5 3 Trans X
Jul-28-05 Jul-19-05 9 5 3 Trans X
Jul-28-05 Jul-19-05 9 5 3 Trans X
Jul-28-05 Jul-19-05 9 5 3 Trans X
Jul-28-05 Jul-19-05 9 5 3 Trans X
Jul-28-05 Jul-19-05 9 5 3 Trans X
Jul-19-05 Jul-19-05 0 5 3 Trans X
"Mark B via OfficeKB.com" wrote:
I think that the first question that needs to be answered is: Why are the
cells colored yellow? Are they colored yellow because of their location or
because they represent a subtotal or some other reason? Once that is
answered it may be easier to proceed. While it appears possible to make the
value of a cell equal something else based upon it's color, I believe it is
an advanced method. We may be able to solve your problem in a simpler manner.
Connie Martin wrote:
I have a huge spreadsheet of data. Certain cells are coloured yellow. What
I would like is a formula that I can enter in all the cells of the column
that would say: "If this particular cell is coloured yellow then it should
equal O43, otherwise it's to be left blank."
Thank you
Connie
--
Mark Brindamour
Message posted via http://www.officekb.com