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