Excel Conditional Formatting

    Share

    Ev
    Franchise Player
    Franchise Player

    Number of posts : 20747
    Registration date : 2010-02-09

    Re: Excel Conditional Formatting

    Post by Ev on Mon Dec 02, 2013 3:08 pm

    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.

    Ev
    Franchise Player
    Franchise Player

    Number of posts : 20747
    Registration date : 2010-02-09

    Re: Excel Conditional Formatting

    Post by Ev on Mon Dec 02, 2013 3:11 pm

    wait i migth be confused lol, just a sec

    Ev
    Franchise Player
    Franchise Player

    Number of posts : 20747
    Registration date : 2010-02-09

    Re: Excel Conditional Formatting

    Post by Ev on Mon Dec 02, 2013 3:14 pm

    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.
    avatar
    spader
    All-Star
    All-Star

    Number of posts : 10037
    Age : 37
    Location : La Loche, Saskatchewan
    Favorite Team : Ottawa
    Registration date : 2009-07-09

    Re: Excel Conditional Formatting

    Post by spader on Mon Dec 02, 2013 10:31 pm

    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.
    avatar
    wprager
    Administrator
    Administrator

    Number of posts : 47611
    Age : 55
    Location : Kanata
    Favorite Team : Ottawa
    Registration date : 2008-08-05

    Re: Excel Conditional Formatting

    Post by wprager on Tue Dec 03, 2013 1:23 am

    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


    _________________
    Hey, I don't have all the answers. In life, to be honest, I've failed as much as I have succeeded. But I love my wife. I love my life. And I wish you my kind of success.
    - Dicky Fox
    avatar
    shabbs
    Hall of Famer
    Hall of Famer

    Number of posts : 31416
    Location : I'm sorry, I can't hear you over the sound of how awesome I am.
    Favorite Team : Ottawa
    Registration date : 2008-08-12

    Re: Excel Conditional Formatting

    Post by shabbs on Tue Dec 03, 2013 10:02 am

    Hilarious!
    avatar
    Ev
    Franchise Player
    Franchise Player

    Number of posts : 20747
    Age : 26
    Location : We The North
    Favorite Team : Ottawa
    Registration date : 2010-02-09

    Re: Excel Conditional Formatting

    Post by Ev on Wed Dec 04, 2013 11:38 am

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

    Number of posts : 47611
    Age : 55
    Location : Kanata
    Favorite Team : Ottawa
    Registration date : 2008-08-05

    Re: Excel Conditional Formatting

    Post by wprager on Fri Dec 06, 2013 6:36 pm

    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?


    _________________
    Hey, I don't have all the answers. In life, to be honest, I've failed as much as I have succeeded. But I love my wife. I love my life. And I wish you my kind of success.
    - Dicky Fox

    Sponsored content

    Re: Excel Conditional Formatting

    Post by Sponsored content


      Current date/time is Sun Jul 23, 2017 2:46 am