+ Reply to Thread
Results 1 to 13 of 13

Formula to change rows a different colour?

  1. #1
    FSt1
    Guest

    RE: Formula to change rows a different colour?

    hi,
    Formulas return a value, they can not perform an action. like change the
    color of a cell.
    but you an use conditional formating to do that.
    Format>Conditional formating
    cell value is Equal to ="yes"
    Format button>pattern tab>some color
    OK

    as to your formula, yes, you can change the text.

    =if(TODAY()-D11>=60,"Yes","No")

    just be sure that the text you want displayed is inclosed in double quotes.
    "Text"

    regards
    FSt1

    "John" wrote:

    > Hi.
    >
    > Today I made a formula for calculating if the date in a column is
    > older than 60 days or not.
    >
    > This is the formula:
    >
    > =IF(TODAY()-D11>=60,TRUE,FALSE)
    >
    > If I want all the ones that are True for the rows to be turned a
    > different colour how can I do this part?
    >
    > And as far as the true and false part goes, does it always have to be
    > these words? Is it possible to get the formula to display other words
    > instead like a YES or a NO? When I type over the true and false to
    > change them to a yes and no, it comes up with an error, so I believe
    > these words are a vital part of the VB code?
    >
    > Thanks for your help
    >
    > John
    >
    >
    >


  2. #2
    John
    Guest

    Re: Formula to change rows a different colour?

    On Wed, 10 Aug 2005 11:11:01 -0700, A strange species called "FSt1"
    <FSt1@discussions.microsoft.com> wrote:

    >hi,
    >Formulas return a value, they can not perform an action. like change the
    >color of a cell.
    >but you an use conditional formating to do that.
    >Format>Conditional formating
    >cell value is Equal to ="yes"
    >Format button>pattern tab>some color
    >OK
    >
    >as to your formula, yes, you can change the text.
    >
    >=if(TODAY()-D11>=60,"Yes","No")
    >
    >just be sure that the text you want displayed is inclosed in double quotes.
    >"Text"
    >
    >regards
    >FSt1


    Thanks a lot mate! This is perfect. I always wondered how this was
    done. Now I know. Conditional Formatting

    This is definitely the most useful thing I have learned this month.

    John



  3. #3
    FSt1
    Guest

    RE: Formula to change rows a different colour?

    hi,
    Formulas return a value, they can not perform an action. like change the
    color of a cell.
    but you an use conditional formating to do that.
    Format>Conditional formating
    cell value is Equal to ="yes"
    Format button>pattern tab>some color
    OK

    as to your formula, yes, you can change the text.

    =if(TODAY()-D11>=60,"Yes","No")

    just be sure that the text you want displayed is inclosed in double quotes.
    "Text"

    regards
    FSt1

    "John" wrote:

    > Hi.
    >
    > Today I made a formula for calculating if the date in a column is
    > older than 60 days or not.
    >
    > This is the formula:
    >
    > =IF(TODAY()-D11>=60,TRUE,FALSE)
    >
    > If I want all the ones that are True for the rows to be turned a
    > different colour how can I do this part?
    >
    > And as far as the true and false part goes, does it always have to be
    > these words? Is it possible to get the formula to display other words
    > instead like a YES or a NO? When I type over the true and false to
    > change them to a yes and no, it comes up with an error, so I believe
    > these words are a vital part of the VB code?
    >
    > Thanks for your help
    >
    > John
    >
    >
    >


  4. #4
    John
    Guest

    Re: Formula to change rows a different colour?

    On Wed, 10 Aug 2005 11:11:01 -0700, A strange species called "FSt1"
    <FSt1@discussions.microsoft.com> wrote:

    >hi,
    >Formulas return a value, they can not perform an action. like change the
    >color of a cell.
    >but you an use conditional formating to do that.
    >Format>Conditional formating
    >cell value is Equal to ="yes"
    >Format button>pattern tab>some color
    >OK
    >
    >as to your formula, yes, you can change the text.
    >
    >=if(TODAY()-D11>=60,"Yes","No")
    >
    >just be sure that the text you want displayed is inclosed in double quotes.
    >"Text"
    >
    >regards
    >FSt1


    Thanks a lot mate! This is perfect. I always wondered how this was
    done. Now I know. Conditional Formatting

    This is definitely the most useful thing I have learned this month.

    John



  5. #5
    FSt1
    Guest

    RE: Formula to change rows a different colour?

    hi,
    Formulas return a value, they can not perform an action. like change the
    color of a cell.
    but you an use conditional formating to do that.
    Format>Conditional formating
    cell value is Equal to ="yes"
    Format button>pattern tab>some color
    OK

    as to your formula, yes, you can change the text.

    =if(TODAY()-D11>=60,"Yes","No")

    just be sure that the text you want displayed is inclosed in double quotes.
    "Text"

    regards
    FSt1

    "John" wrote:

    > Hi.
    >
    > Today I made a formula for calculating if the date in a column is
    > older than 60 days or not.
    >
    > This is the formula:
    >
    > =IF(TODAY()-D11>=60,TRUE,FALSE)
    >
    > If I want all the ones that are True for the rows to be turned a
    > different colour how can I do this part?
    >
    > And as far as the true and false part goes, does it always have to be
    > these words? Is it possible to get the formula to display other words
    > instead like a YES or a NO? When I type over the true and false to
    > change them to a yes and no, it comes up with an error, so I believe
    > these words are a vital part of the VB code?
    >
    > Thanks for your help
    >
    > John
    >
    >
    >


  6. #6
    John
    Guest

    Re: Formula to change rows a different colour?

    On Wed, 10 Aug 2005 11:11:01 -0700, A strange species called "FSt1"
    <FSt1@discussions.microsoft.com> wrote:

    >hi,
    >Formulas return a value, they can not perform an action. like change the
    >color of a cell.
    >but you an use conditional formating to do that.
    >Format>Conditional formating
    >cell value is Equal to ="yes"
    >Format button>pattern tab>some color
    >OK
    >
    >as to your formula, yes, you can change the text.
    >
    >=if(TODAY()-D11>=60,"Yes","No")
    >
    >just be sure that the text you want displayed is inclosed in double quotes.
    >"Text"
    >
    >regards
    >FSt1


    Thanks a lot mate! This is perfect. I always wondered how this was
    done. Now I know. Conditional Formatting

    This is definitely the most useful thing I have learned this month.

    John



  7. #7
    FSt1
    Guest

    RE: Formula to change rows a different colour?

    hi,
    Formulas return a value, they can not perform an action. like change the
    color of a cell.
    but you an use conditional formating to do that.
    Format>Conditional formating
    cell value is Equal to ="yes"
    Format button>pattern tab>some color
    OK

    as to your formula, yes, you can change the text.

    =if(TODAY()-D11>=60,"Yes","No")

    just be sure that the text you want displayed is inclosed in double quotes.
    "Text"

    regards
    FSt1

    "John" wrote:

    > Hi.
    >
    > Today I made a formula for calculating if the date in a column is
    > older than 60 days or not.
    >
    > This is the formula:
    >
    > =IF(TODAY()-D11>=60,TRUE,FALSE)
    >
    > If I want all the ones that are True for the rows to be turned a
    > different colour how can I do this part?
    >
    > And as far as the true and false part goes, does it always have to be
    > these words? Is it possible to get the formula to display other words
    > instead like a YES or a NO? When I type over the true and false to
    > change them to a yes and no, it comes up with an error, so I believe
    > these words are a vital part of the VB code?
    >
    > Thanks for your help
    >
    > John
    >
    >
    >


  8. #8
    John
    Guest

    Re: Formula to change rows a different colour?

    On Wed, 10 Aug 2005 11:11:01 -0700, A strange species called "FSt1"
    <FSt1@discussions.microsoft.com> wrote:

    >hi,
    >Formulas return a value, they can not perform an action. like change the
    >color of a cell.
    >but you an use conditional formating to do that.
    >Format>Conditional formating
    >cell value is Equal to ="yes"
    >Format button>pattern tab>some color
    >OK
    >
    >as to your formula, yes, you can change the text.
    >
    >=if(TODAY()-D11>=60,"Yes","No")
    >
    >just be sure that the text you want displayed is inclosed in double quotes.
    >"Text"
    >
    >regards
    >FSt1


    Thanks a lot mate! This is perfect. I always wondered how this was
    done. Now I know. Conditional Formatting

    This is definitely the most useful thing I have learned this month.

    John



  9. #9
    FSt1
    Guest

    RE: Formula to change rows a different colour?

    hi,
    Formulas return a value, they can not perform an action. like change the
    color of a cell.
    but you an use conditional formating to do that.
    Format>Conditional formating
    cell value is Equal to ="yes"
    Format button>pattern tab>some color
    OK

    as to your formula, yes, you can change the text.

    =if(TODAY()-D11>=60,"Yes","No")

    just be sure that the text you want displayed is inclosed in double quotes.
    "Text"

    regards
    FSt1

    "John" wrote:

    > Hi.
    >
    > Today I made a formula for calculating if the date in a column is
    > older than 60 days or not.
    >
    > This is the formula:
    >
    > =IF(TODAY()-D11>=60,TRUE,FALSE)
    >
    > If I want all the ones that are True for the rows to be turned a
    > different colour how can I do this part?
    >
    > And as far as the true and false part goes, does it always have to be
    > these words? Is it possible to get the formula to display other words
    > instead like a YES or a NO? When I type over the true and false to
    > change them to a yes and no, it comes up with an error, so I believe
    > these words are a vital part of the VB code?
    >
    > Thanks for your help
    >
    > John
    >
    >
    >


  10. #10
    John
    Guest

    Re: Formula to change rows a different colour?

    On Wed, 10 Aug 2005 11:11:01 -0700, A strange species called "FSt1"
    <FSt1@discussions.microsoft.com> wrote:

    >hi,
    >Formulas return a value, they can not perform an action. like change the
    >color of a cell.
    >but you an use conditional formating to do that.
    >Format>Conditional formating
    >cell value is Equal to ="yes"
    >Format button>pattern tab>some color
    >OK
    >
    >as to your formula, yes, you can change the text.
    >
    >=if(TODAY()-D11>=60,"Yes","No")
    >
    >just be sure that the text you want displayed is inclosed in double quotes.
    >"Text"
    >
    >regards
    >FSt1


    Thanks a lot mate! This is perfect. I always wondered how this was
    done. Now I know. Conditional Formatting

    This is definitely the most useful thing I have learned this month.

    John



  11. #11
    John
    Guest

    Formula to change rows a different colour?

    Hi.

    Today I made a formula for calculating if the date in a column is
    older than 60 days or not.

    This is the formula:

    =IF(TODAY()-D11>=60,TRUE,FALSE)

    If I want all the ones that are True for the rows to be turned a
    different colour how can I do this part?

    And as far as the true and false part goes, does it always have to be
    these words? Is it possible to get the formula to display other words
    instead like a YES or a NO? When I type over the true and false to
    change them to a yes and no, it comes up with an error, so I believe
    these words are a vital part of the VB code?

    Thanks for your help

    John



  12. #12
    FSt1
    Guest

    RE: Formula to change rows a different colour?

    hi,
    Formulas return a value, they can not perform an action. like change the
    color of a cell.
    but you an use conditional formating to do that.
    Format>Conditional formating
    cell value is Equal to ="yes"
    Format button>pattern tab>some color
    OK

    as to your formula, yes, you can change the text.

    =if(TODAY()-D11>=60,"Yes","No")

    just be sure that the text you want displayed is inclosed in double quotes.
    "Text"

    regards
    FSt1

    "John" wrote:

    > Hi.
    >
    > Today I made a formula for calculating if the date in a column is
    > older than 60 days or not.
    >
    > This is the formula:
    >
    > =IF(TODAY()-D11>=60,TRUE,FALSE)
    >
    > If I want all the ones that are True for the rows to be turned a
    > different colour how can I do this part?
    >
    > And as far as the true and false part goes, does it always have to be
    > these words? Is it possible to get the formula to display other words
    > instead like a YES or a NO? When I type over the true and false to
    > change them to a yes and no, it comes up with an error, so I believe
    > these words are a vital part of the VB code?
    >
    > Thanks for your help
    >
    > John
    >
    >
    >


  13. #13
    John
    Guest

    Re: Formula to change rows a different colour?

    On Wed, 10 Aug 2005 11:11:01 -0700, A strange species called "FSt1"
    <FSt1@discussions.microsoft.com> wrote:

    >hi,
    >Formulas return a value, they can not perform an action. like change the
    >color of a cell.
    >but you an use conditional formating to do that.
    >Format>Conditional formating
    >cell value is Equal to ="yes"
    >Format button>pattern tab>some color
    >OK
    >
    >as to your formula, yes, you can change the text.
    >
    >=if(TODAY()-D11>=60,"Yes","No")
    >
    >just be sure that the text you want displayed is inclosed in double quotes.
    >"Text"
    >
    >regards
    >FSt1


    Thanks a lot mate! This is perfect. I always wondered how this was
    done. Now I know. Conditional Formatting

    This is definitely the most useful thing I have learned this month.

    John



+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1