I apologize for how simple this question probably is. I have created a log
in Excel 2003 to track submittals we receive. These submittals are either
approved, approved as noted, revised and resubmit, or rejected. I have
columns set up to track the dates and names of the submittals as well as a
column for each of the four possible responses. I type an "X" in the
appropriate cell to designate approval status. I have been manually shading
rows yellow for approved and approved as noted, blue for revised and resubmit
and red for rejected and leaving them with no shading if I haven't received
the submittal yet. Is it possible to do this?