+ Reply to Thread
Results 1 to 5 of 5

set "value if true" to "fill cell with color"

  1. #1
    Feeta
    Guest

    set "value if true" to "fill cell with color"

    I want to use an IF statement to check for text in a cell range and if true,
    then fill a cell with a highlight color. In my application, I would look for
    "PD" in invoice date fields and if found, highlight the amount invoiced in
    green. I don't know the snytax to write the return value as "fill this cell
    with color".

  2. #2
    Trevor Shuttleworth
    Guest

    Re: set "value if true" to "fill cell with color"

    You can't do what you want in the way that you describe, that is, with a
    formula. Have a look at conditional formatting. That will do what you
    want.

    Assume that your invoice dates are in column C, starting in row 2. In Cell
    D2, or whatever:

    Format | Conditional Formatting... | Condition 1: Formula is | =C2="pd"

    Change the format as required, for example, Format | Patterns = green

    Copy the formatting to the other cells you want to highlight.

    Regards

    Trevor


    "Feeta" <Feeta@discussions.microsoft.com> wrote in message
    news:4681D0C4-E935-4DCC-B8DF-06FF47FB2068@microsoft.com...
    >I want to use an IF statement to check for text in a cell range and if
    >true,
    > then fill a cell with a highlight color. In my application, I would look
    > for
    > "PD" in invoice date fields and if found, highlight the amount invoiced in
    > green. I don't know the snytax to write the return value as "fill this
    > cell
    > with color".




  3. #3
    STEVE BELL
    Guest

    Re: set "value if true" to "fill cell with color"

    Check out Conditional Formatting...

    No code required. Just use a formula condition.

    --
    steveB

    Remove "AYN" from email to respond
    "Feeta" <Feeta@discussions.microsoft.com> wrote in message
    news:4681D0C4-E935-4DCC-B8DF-06FF47FB2068@microsoft.com...
    >I want to use an IF statement to check for text in a cell range and if
    >true,
    > then fill a cell with a highlight color. In my application, I would look
    > for
    > "PD" in invoice date fields and if found, highlight the amount invoiced in
    > green. I don't know the snytax to write the return value as "fill this
    > cell
    > with color".




  4. #4
    Feeta
    Guest

    Re: set "value if true" to "fill cell with color"

    Thank you, this is exactly what I needed to know. I appreciate the detail you
    provided.

    "Trevor Shuttleworth" wrote:

    > You can't do what you want in the way that you describe, that is, with a
    > formula. Have a look at conditional formatting. That will do what you
    > want.
    >
    > Assume that your invoice dates are in column C, starting in row 2. In Cell
    > D2, or whatever:
    >
    > Format | Conditional Formatting... | Condition 1: Formula is | =C2="pd"
    >
    > Change the format as required, for example, Format | Patterns = green
    >
    > Copy the formatting to the other cells you want to highlight.
    >
    > Regards
    >
    > Trevor
    >
    >
    > "Feeta" <Feeta@discussions.microsoft.com> wrote in message
    > news:4681D0C4-E935-4DCC-B8DF-06FF47FB2068@microsoft.com...
    > >I want to use an IF statement to check for text in a cell range and if
    > >true,
    > > then fill a cell with a highlight color. In my application, I would look
    > > for
    > > "PD" in invoice date fields and if found, highlight the amount invoiced in
    > > green. I don't know the snytax to write the return value as "fill this
    > > cell
    > > with color".

    >
    >
    >


  5. #5
    Trevor Shuttleworth
    Guest

    Re: set "value if true" to "fill cell with color"

    You're welcome, thanks for the feedback.


    "Feeta" <Feeta@discussions.microsoft.com> wrote in message
    news:3436EEAB-DC20-4EC3-A89A-D271F567E318@microsoft.com...
    > Thank you, this is exactly what I needed to know. I appreciate the detail
    > you
    > provided.
    >
    > "Trevor Shuttleworth" wrote:
    >
    >> You can't do what you want in the way that you describe, that is, with a
    >> formula. Have a look at conditional formatting. That will do what you
    >> want.
    >>
    >> Assume that your invoice dates are in column C, starting in row 2. In
    >> Cell
    >> D2, or whatever:
    >>
    >> Format | Conditional Formatting... | Condition 1: Formula is | =C2="pd"
    >>
    >> Change the format as required, for example, Format | Patterns = green
    >>
    >> Copy the formatting to the other cells you want to highlight.
    >>
    >> Regards
    >>
    >> Trevor
    >>
    >>
    >> "Feeta" <Feeta@discussions.microsoft.com> wrote in message
    >> news:4681D0C4-E935-4DCC-B8DF-06FF47FB2068@microsoft.com...
    >> >I want to use an IF statement to check for text in a cell range and if
    >> >true,
    >> > then fill a cell with a highlight color. In my application, I would
    >> > look
    >> > for
    >> > "PD" in invoice date fields and if found, highlight the amount invoiced
    >> > in
    >> > green. I don't know the snytax to write the return value as "fill this
    >> > cell
    >> > with color".

    >>
    >>
    >>




+ 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