Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 3 of 3

Thread: Conditional formatting in if statement

  1. #1
    Board Regular
    Join Date
    Apr 2002
    Location
    Wilmington North Carolina USA
    Posts
    161
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Can I insert conditional formatting in an if statement? For example if (b5>b6, b5, "out of balance") with the phrase out of balance printed bold and in red?

    Thanks to all

  2. #2
    Board Regular
    Join Date
    Feb 2002
    Location
    Where the wild roses grow
    Posts
    285
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    You cant do it within the formula

    Just do the formula as normal, then highlight the cell and go into conditional formatting as usual. Make the condition Equal To and then just type Out Of Balance in the field and set the required format

    Audiojoe

    [ This Message was edited by: Audiojoe on 2002-05-13 07:01 ]

  3. #3
    Board Regular
    Join Date
    Apr 2002
    Location
    Wilmington North Carolina USA
    Posts
    161
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Thanks, Joe.

    Steve

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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