Formula Help Please

[STEINEKIN]

So I have been given the task of creating an excel table in 03 that needs to
do a couple of things and I am new to excel and not good at formulas:

First: when a date is entered into Column E i need a 5 day countdown to
return a color change in corresponding row in column A
Day 1= Blue
Day 2= Purple
Day3=Yellow
Day 4=Orange
Day 5 = Red

Second: when any date is entered into Column G i need the corresponding Row
in Column A to turn Green and overtake the first rule and stay green
permanently

any help would be grateful!

 

[Gord Dibben]

First of all.............xl2003 does not allow more than 3 conditional
formats(4 if you count default color)

So you would have to use VBA code to achieve your coloring.

Second of all..........how is the countdown to be achieved?

Where would that value appear?

Please use cell references rather than Column and row references.

Like E1 and A1 and G1


Gord Dibben MS Excel MVP