Amongst others, my spreadsheet headings include "Product Code" and each
day of the month. The status of the "Product Code" can change from day
to day. At some stage the status will change to "Passed" or "Reject".
This change can appear under any date heading.
When the status changes to "Passed", the cell colour of "Product Code"
must change to green and when status becomes "Reject" it must change to
red.
Should the status initially be "Passed" and later change to "Reject",
the colour must change to orange.
Please refer attachment.


+-------------------------------------------------------------------+
|Filename: Batch Status Report2.pdf |
|Download: http://www.excelforum.com/attachment.php?postid=5050 |
+-------------------------------------------------------------------+

--
Hennie
------------------------------------------------------------------------
Hennie's Profile: http://www.excelforum.com/member.php...nfo&userid=399
View this thread: http://www.excelforum.com/showthread...hreadid=562610