+ Reply to Thread
Results 1 to 2 of 2

formulae 4 conditioanl formating

  1. #1
    Registered User
    Join Date
    08-02-2007
    Posts
    1

    formulae 4 conditioanl formating

    hii everyone,

    i need a formula that automatically changes the font color of a cell i.e

    A B

    1 12 56
    2 45 63
    3 98 101
    4 7.70 7.75
    5 35 32
    6 67 66

    my question WHEN ENTERING DATA IN COL B1, IF A1>B1, FONT COLOR BLUE

    IF A1<B1, FONT COLOR GREEEN.

    CAN SMN PLZ CLARIFY ME ON THIS ITEM. THANKS

  2. #2
    Forum Expert daddylonglegs's Avatar
    Join Date
    01-14-2006
    Location
    England
    MS-Off Ver
    2016
    Posts
    14,675
    Select entire column B and use

    Format > Conditional Formatting > Formula is

    =A1>B1

    select blue pattern or font

    add condition and apply

    =A1<B1

    as condition 2

    apply green format as before

+ 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