Excel formula help

Kol

Kol

Kol

Man of Honour
Joined
8 Jan 2003
Posts
14,343
Location
Ashby-de-la-Zouch
Hi guys,

I wonder if any of you gurus can help me? Say along the top of my spreadsheet I have the following:

name - week1 - week2 - week3 (onwards) to week 52

Is there any way I can get excel to compare week2 to week1 and week3 to week2 and so on and then give me a simple RED box or a GREEN box to show whether the value has gone up or down? So it would be:

name - week1 - week2(red/green fill) - week3 (red/green fill) ?

and then at the end say it goes:

week52 - overall (red/green fill)

where the overall basically compares there overall performance with regards to their first week?

Cheers chaps!
 
rafster, you may have to elaborate for me mate as I'm not too great with excel so ideally would need it in laymans terms, ie. the formula! :)

Ah you've edited! Thanky you! I'll give that a shot right now :)
 
Last edited:
OK - that's great, it works. Is there anyway of dragging this conditional formatting down?

So a2 works with a3
b2 works with b3

etc. and also dragging it across, so a3 will work with a4, b3 with b4 etc?
 
That just drags the value that is typed into the box, ie. the 82.5%, not the conditional formatting :(

annoyingly, the values have already been entered (if that causes any problems).
 
OK - I've been playing. I made sure the absolute references were taken out, then I used format painter. Wow, what an awersome tool, both conditional formatting and format painter!

Cheers for your help chaps!
 
Last edited:
You must log in or register to reply here.
Back
Top Bottom