ie, when entering data into a speadsheet if 1 entered 1 the cell would go red, 2 orange etc
Z zoe Apr 26, 2006 #1 ie, when entering data into a speadsheet if 1 entered 1 the cell would go red, 2 orange etc
F FSt1 Apr 26, 2006 #2 hi, you can use conditional formating for up to 3 colors. if you want more you will have to use a macro using the worksheet change event. regards FSt1
hi, you can use conditional formating for up to 3 colors. if you want more you will have to use a macro using the worksheet change event. regards FSt1
