Excel Conditional Formatting

No I don't need how many months have passed,

The formula works, I just did it.

You put in March 31, 2013 as future date, - today, and it gives you 4. That's correct.

wait i migth be confused lol, just a sec

Ah ok I forgot to say that I already got the first part done (the one you just wrote). But then I needed the amount of months from now until March 31, whcih I added. It's all good now.

wprager wrote:Which version of Excel?  Do you want the cell to change based on its own value or based on another cell?  Do you want it based on the same cell for all cells where you want the change or based on same row/different column, or same column/different row?

Lots of questions to be answered.

P.S. I *am* good with this stuff.

This is good to know. Expect some more requests for help in the future. I don't use the program very often because I've never been able to really get the hang of it.

spader wrote:

wprager wrote:Which version of Excel?  Do you want the cell to change based on its own value or based on another cell?  Do you want it based on the same cell for all cells where you want the change or based on same row/different column, or same column/different row?

Lots of questions to be answered.

P.S. I *am* good with this stuff.

This is good to know. Expect some more requests for help in the future. I don't use the program very often because I've never been able to really get the hang of it.

You can use Excel to make it look completely not like Excel. Someone wrote a Tetris program in Excel. And it's not just changing cell background colors to make it look like tiles falling down (like this one). The VBA was locked down under password so I could not easily take a look at how they did it, but it was like a real Tetris game.

Let me see if I can find it ...

Got it!

http://www.google.ca/url?sa=t&rct=j&q=&esrc=s&source=web&cd=2&ved=0CDQQFjAB&url=http%3A%2F%2Fwww.cosmicadventure.com%2Ffun%2FTetris.xls&ei=aHCdUpCcJ7KusATMyoDgCQ&usg=AFQjCNFqKP-RA_T0b5Scg70jQwtz3dEeCQ&sig2=6QwRO2U5geRx9WS_S4i2Fw&bvm=bv.57155469,d.cWc

Hilarious!

how the Diddle do i sort by colour, it won't work since I have merged cells up top

What do you mean sort by colour? You can sort by cell value. Colour is a property, not a value. Do you want to assign values to colors and sort like that?