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

Thread: Conditional Formttg : using the Formula drop down.

  1. #1
    Board Regular
    Join Date
    Feb 2002
    Location
    Mike
    Posts
    796
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    I'm pretty good at using Cond Formtg for "values", but not too good when using the Formula drop down.
    What formula can I use to do the following:
    In C5 I will have a 0 or Higher.
    In G5 I want the following result:
    - If C5 = 0
    - Then make the place a 0 in Bold/Red
    - If >0 Make the Font Bold Black/Light Blue Cell.

    My problem is how I tie C5 into the picture as simply as possible.

    Thanks,
    Mike

    [ This Message was edited by: Zac on 2002-02-27 13:23 ]

  2. #2
    Board Regular
    Join Date
    Feb 2002
    Location
    Mike
    Posts
    796
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Figured it out.
    I put an IF statement in G5, that places a zero here if C5 = 0. Then used Conditional Fornmtg from there to change colors based on the values in G5.

  3. #3
    MrExcel MVP Aladin Akyurek's Avatar
    Join Date
    Feb 2002
    Location
    The Hague, NL
    Posts
    84,074
    Post Thanks / Like
    Mentioned
    38 Post(s)
    Tagged
    8 Thread(s)

    Default


    Activate G5.
    Activate Format|Conditional Formatting.
    Choose "Formula Is" and enter in the formula box:

    =$C$5=0

    Activate "Format".
    Select the desired formatting on the Font tab appropriate for the 0 condition.
    Click OK.
    Activate Add.
    Choose "Formula Is" for Condition 2 and enter in the formula box:

    =$C$5>0

    Activate "Format" and the appropriate formatting.


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
  •