+ Reply to Thread
Results 1 to 2 of 2

Cell Formatting If In Budget Cell become Green and If over budget cell become Red

  1. #1
    Registered User
    Join Date
    08-17-2012
    Location
    India, Baroda
    MS-Off Ver
    Excel 2007
    Posts
    14

    Cell Formatting If In Budget Cell become Green and If over budget cell become Red

    Dear All,

    Can anyone help me out that I have been trying

    If SMPS price is greater than budget price that cell comes to Over Budget ok but what i need G2 item Over budget cell becomes red and G8 item under budget cell become green other wise cell stay white. is it possible or any kind of formula have make that possible.

    see the sample file

    Regards,Book1.xls

  2. #2
    Forum Expert Ace_XL's Avatar
    Join Date
    06-04-2012
    Location
    UAE
    MS-Off Ver
    2016
    Posts
    6,074

    Re: Cell Formatting If In Budget Cell become Green and If over budget cell become Red

    Use Conditional formatting in Column G.

    Cell value--equals--Over Budget--red
    Cell value--equals--Under Budget--green

    See attached. Does this help?
    Life's a spreadsheet, Excel!
    Say thanks, Click *

+ 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