Results 1 to 4 of 4

Thread: Conditional formula

  1. #1
    Board Regular
    Join Date
    Sep 2010
    Posts
    272
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Conditional formula

    I need a formula for conditional formatting that will color a font based on the condition that compares the value in H12 through S12 to the value in H13 through S13. If line 12 is of lesser value than 12, color the font red.

    thanks in advance

  2. #2
    Board Regular DanteAmor's Avatar
    Join Date
    Dec 2018
    Location
    México
    Posts
    6,260
    Post Thanks / Like
    Mentioned
    72 Post(s)
    Tagged
    14 Thread(s)

    Default Re: Conditional formula

    Try this:

    - Select cells H12 through S12
    - on conditional formatting, Put this formula

    =H$12 < H$13

    - Select the font color in format
    Last edited by DanteAmor; Aug 20th, 2019 at 04:46 PM.
    Regards Dante Amor

  3. #3
    Board Regular
    Join Date
    Sep 2010
    Posts
    272
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Conditional formula

    Thanks

  4. #4
    Board Regular DanteAmor's Avatar
    Join Date
    Dec 2018
    Location
    México
    Posts
    6,260
    Post Thanks / Like
    Mentioned
    72 Post(s)
    Tagged
    14 Thread(s)

    Default Re: Conditional formula

    Your welcome & thanks for the feedback.
    Regards Dante Amor

Some videos you may like

User Tag List

Tags for this Thread

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
  •