I'm new at conditional formatting and would like to know how to get the
following to change if a line is changed
Item ID         Long Description          Status    Date Changed           New
50100050      Drill, Pivot                     A
50100051      Drill, Pivot                      I
50100052      Drill, Pivot                                                  
            Y
50100053      Drill, Pivot                                   3/12/07

Item ...50  is black
Item ...51  is red
Item ...52 should be blue and a date entered
Item ...53 should be pink
Item ...54 is black

On Item 50 if I add a date, the font doesn't change or change A to I it
doesn't change
Can anyone help me?
Thank you