ashleydhall
New member
- Local time
- Today, 00:22
- Joined
- May 27, 2009
- Messages
- 2
Hi I'm pretty new to excel and havent a clue with vba, I have done a few things with conditional formatting but im now stuck with a auto cell colouring problem.
Basically what i want to do is have the colour of a cell change to red or yellow depending on the value entered compared to the previous cell's value, this is for a weekly sales comparison which is attached {attached copy has cells manually coloured}
e.g.
c11 has the value 5.84 so when i put 3.95 into d11 like i have already done i want the cell to turn red to recognise that its a lower value than the previous cell{weeks} value. if you go to e11 the value is 6.83 highlighted yellow to show an increase.
i have seen conditional formatting to change colour if above or below a certain value but not above or below another cells value.
also this would have to apply to all the cells in i.e. sales row dept named rows i.e. tennis, football etc.
thankyou
ashley
Basically what i want to do is have the colour of a cell change to red or yellow depending on the value entered compared to the previous cell's value, this is for a weekly sales comparison which is attached {attached copy has cells manually coloured}
e.g.
c11 has the value 5.84 so when i put 3.95 into d11 like i have already done i want the cell to turn red to recognise that its a lower value than the previous cell{weeks} value. if you go to e11 the value is 6.83 highlighted yellow to show an increase.
i have seen conditional formatting to change colour if above or below a certain value but not above or below another cells value.
also this would have to apply to all the cells in i.e. sales row dept named rows i.e. tennis, football etc.
thankyou

ashley