+ Reply to Thread
Results 1 to 10 of 10

formatting a cell with a function (IF statement)

  1. 09-06-2005, 01:05 AM #1
    CLR
    Guest

    Re: formatting a cell with a function (IF statement)

    Highlight cell A1.........then do Format > ConditionalFormatting >
    CellValueIs > Greater than > 1400 > Format > PatternsTab > choose RED > OK >
    OK................

    Vaya con Dios,
    Chuck, CABGx3


    "Dreaming" <Dreaming@discussions.microsoft.com> wrote in message
    news:E5EF3893-40EA-42B2-995A-35E7F89B5C60@microsoft.com...
    > I'm wondering if it is possible to format a cell say, color it by using an
    IF
    > statement, perhaps using a macro?. My if statement is: =IF(A1>1400,"X","
    > "), but instead of the "X" I would like the cell to turn red. Am I
    dreaming
    > of impossibilities?
    >
    > --
    > Cheerio
    >


    Reply With QuoteRegister To Reply
  2. 09-06-2005, 01:05 AM #2
    Dreaming
    Guest

    Re: formatting a cell with a function (IF statement)

    Thank you, will try!
    --
    Cheerio



    "CLR" wrote:

    > Highlight cell A1.........then do Format > ConditionalFormatting >
    > CellValueIs > Greater than > 1400 > Format > PatternsTab > choose RED > OK >
    > OK................
    >
    > Vaya con Dios,
    > Chuck, CABGx3
    >
    >
    > "Dreaming" <Dreaming@discussions.microsoft.com> wrote in message
    > news:E5EF3893-40EA-42B2-995A-35E7F89B5C60@microsoft.com...
    > > I'm wondering if it is possible to format a cell say, color it by using an
    > IF
    > > statement, perhaps using a macro?. My if statement is: =IF(A1>1400,"X","
    > > "), but instead of the "X" I would like the cell to turn red. Am I
    > dreaming
    > > of impossibilities?
    > >
    > > --
    > > Cheerio
    > >
    >
    >
    >
    Reply With QuoteRegister To Reply
  3. 09-06-2005, 01:05 AM #3
    CLR
    Guest

    Re: formatting a cell with a function (IF statement)

    My Bad..........sorry.........I didn't read closely enough..........Biff is
    right, you need to use the INDIRECT statement that he suggested to work
    between sheets...........or, you could link Sheet1!A1 into Sheet2 and use it
    from there..........

    Vaya con Dios,
    Chuck, CABGx3


    "Dreaming" <Dreaming@discussions.microsoft.com> wrote in message
    news:888677E5-57E4-4002-B464-9869B481CF34@microsoft.com...
    > Thank you, will try!
    > --
    > Cheerio
    >
    >
    >
    > "CLR" wrote:
    >
    > > Highlight cell A1.........then do Format > ConditionalFormatting >
    > > CellValueIs > Greater than > 1400 > Format > PatternsTab > choose RED >
    OK >
    > > OK................
    > >
    > > Vaya con Dios,
    > > Chuck, CABGx3
    > >
    > >
    > > "Dreaming" <Dreaming@discussions.microsoft.com> wrote in message
    > > news:E5EF3893-40EA-42B2-995A-35E7F89B5C60@microsoft.com...
    > > > I'm wondering if it is possible to format a cell say, color it by
    using an
    > > IF
    > > > statement, perhaps using a macro?. My if statement is:
    =IF(A1>1400,"X","
    > > > "), but instead of the "X" I would like the cell to turn red. Am I
    > > dreaming
    > > > of impossibilities?
    > > >
    > > > --
    > > > Cheerio
    > > >
    > >
    > >
    > >


    Reply With QuoteRegister To Reply
  4. 09-06-2005, 02:05 AM #4
    CLR
    Guest

    Re: formatting a cell with a function (IF statement)

    Highlight cell A1.........then do Format > ConditionalFormatting >
    CellValueIs > Greater than > 1400 > Format > PatternsTab > choose RED > OK >
    OK................

    Vaya con Dios,
    Chuck, CABGx3


    "Dreaming" <Dreaming@discussions.microsoft.com> wrote in message
    news:E5EF3893-40EA-42B2-995A-35E7F89B5C60@microsoft.com...
    > I'm wondering if it is possible to format a cell say, color it by using an
    IF
    > statement, perhaps using a macro?. My if statement is: =IF(A1>1400,"X","
    > "), but instead of the "X" I would like the cell to turn red. Am I
    dreaming
    > of impossibilities?
    >
    > --
    > Cheerio
    >


    Reply With QuoteRegister To Reply
  5. 09-06-2005, 02:05 AM #5
    Dreaming
    Guest

    Re: formatting a cell with a function (IF statement)

    Thank you, will try!
    --
    Cheerio



    "CLR" wrote:

    > Highlight cell A1.........then do Format > ConditionalFormatting >
    > CellValueIs > Greater than > 1400 > Format > PatternsTab > choose RED > OK >
    > OK................
    >
    > Vaya con Dios,
    > Chuck, CABGx3
    >
    >
    > "Dreaming" <Dreaming@discussions.microsoft.com> wrote in message
    > news:E5EF3893-40EA-42B2-995A-35E7F89B5C60@microsoft.com...
    > > I'm wondering if it is possible to format a cell say, color it by using an
    > IF
    > > statement, perhaps using a macro?. My if statement is: =IF(A1>1400,"X","
    > > "), but instead of the "X" I would like the cell to turn red. Am I
    > dreaming
    > > of impossibilities?
    > >
    > > --
    > > Cheerio
    > >
    >
    >
    >
    Reply With QuoteRegister To Reply
  6. 09-06-2005, 02:05 AM #6
    CLR
    Guest

    Re: formatting a cell with a function (IF statement)

    My Bad..........sorry.........I didn't read closely enough..........Biff is
    right, you need to use the INDIRECT statement that he suggested to work
    between sheets...........or, you could link Sheet1!A1 into Sheet2 and use it
    from there..........

    Vaya con Dios,
    Chuck, CABGx3


    "Dreaming" <Dreaming@discussions.microsoft.com> wrote in message
    news:888677E5-57E4-4002-B464-9869B481CF34@microsoft.com...
    > Thank you, will try!
    > --
    > Cheerio
    >
    >
    >
    > "CLR" wrote:
    >
    > > Highlight cell A1.........then do Format > ConditionalFormatting >
    > > CellValueIs > Greater than > 1400 > Format > PatternsTab > choose RED >
    OK >
    > > OK................
    > >
    > > Vaya con Dios,
    > > Chuck, CABGx3
    > >
    > >
    > > "Dreaming" <Dreaming@discussions.microsoft.com> wrote in message
    > > news:E5EF3893-40EA-42B2-995A-35E7F89B5C60@microsoft.com...
    > > > I'm wondering if it is possible to format a cell say, color it by
    using an
    > > IF
    > > > statement, perhaps using a macro?. My if statement is:
    =IF(A1>1400,"X","
    > > > "), but instead of the "X" I would like the cell to turn red. Am I
    > > dreaming
    > > > of impossibilities?
    > > >
    > > > --
    > > > Cheerio
    > > >
    > >
    > >
    > >


    Reply With QuoteRegister To Reply
  7. 09-06-2005, 07:05 AM #7
    Dreaming
    Guest

    formatting a cell with a function (IF statement)

    I'm wondering if it is possible to format a cell say, color it by using an IF
    statement, perhaps using a macro?. My if statement is: =IF(A1>1400,"X","
    "), but instead of the "X" I would like the cell to turn red. Am I dreaming
    of impossibilities?

    --
    Cheerio

    Reply With QuoteRegister To Reply
  8. 09-06-2005, 07:05 AM #8
    CLR
    Guest

    Re: formatting a cell with a function (IF statement)

    Highlight cell A1.........then do Format > ConditionalFormatting >
    CellValueIs > Greater than > 1400 > Format > PatternsTab > choose RED > OK >
    OK................

    Vaya con Dios,
    Chuck, CABGx3


    "Dreaming" <Dreaming@discussions.microsoft.com> wrote in message
    news:E5EF3893-40EA-42B2-995A-35E7F89B5C60@microsoft.com...
    > I'm wondering if it is possible to format a cell say, color it by using an
    IF
    > statement, perhaps using a macro?. My if statement is: =IF(A1>1400,"X","
    > "), but instead of the "X" I would like the cell to turn red. Am I
    dreaming
    > of impossibilities?
    >
    > --
    > Cheerio
    >


    Reply With QuoteRegister To Reply
  9. 09-06-2005, 07:05 AM #9
    Dreaming
    Guest

    Re: formatting a cell with a function (IF statement)

    Thank you, will try!
    --
    Cheerio



    "CLR" wrote:

    > Highlight cell A1.........then do Format > ConditionalFormatting >
    > CellValueIs > Greater than > 1400 > Format > PatternsTab > choose RED > OK >
    > OK................
    >
    > Vaya con Dios,
    > Chuck, CABGx3
    >
    >
    > "Dreaming" <Dreaming@discussions.microsoft.com> wrote in message
    > news:E5EF3893-40EA-42B2-995A-35E7F89B5C60@microsoft.com...
    > > I'm wondering if it is possible to format a cell say, color it by using an
    > IF
    > > statement, perhaps using a macro?. My if statement is: =IF(A1>1400,"X","
    > > "), but instead of the "X" I would like the cell to turn red. Am I
    > dreaming
    > > of impossibilities?
    > >
    > > --
    > > Cheerio
    > >
    >
    >
    >
    Reply With QuoteRegister To Reply
  10. 09-06-2005, 07:05 AM #10
    CLR
    Guest

    Re: formatting a cell with a function (IF statement)

    My Bad..........sorry.........I didn't read closely enough..........Biff is
    right, you need to use the INDIRECT statement that he suggested to work
    between sheets...........or, you could link Sheet1!A1 into Sheet2 and use it
    from there..........

    Vaya con Dios,
    Chuck, CABGx3


    "Dreaming" <Dreaming@discussions.microsoft.com> wrote in message
    news:888677E5-57E4-4002-B464-9869B481CF34@microsoft.com...
    > Thank you, will try!
    > --
    > Cheerio
    >
    >
    >
    > "CLR" wrote:
    >
    > > Highlight cell A1.........then do Format > ConditionalFormatting >
    > > CellValueIs > Greater than > 1400 > Format > PatternsTab > choose RED >
    OK >
    > > OK................
    > >
    > > Vaya con Dios,
    > > Chuck, CABGx3
    > >
    > >
    > > "Dreaming" <Dreaming@discussions.microsoft.com> wrote in message
    > > news:E5EF3893-40EA-42B2-995A-35E7F89B5C60@microsoft.com...
    > > > I'm wondering if it is possible to format a cell say, color it by
    using an
    > > IF
    > > > statement, perhaps using a macro?. My if statement is:
    =IF(A1>1400,"X","
    > > > "), but instead of the "X" I would like the cell to turn red. Am I
    > > dreaming
    > > > of impossibilities?
    > > >
    > > > --
    > > > Cheerio
    > > >
    > >
    > >
    > >


    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1