+ Reply to Thread
Results 1 to 2 of 2

conditional formatting?

Hybrid View

vahallan conditional formatting? 09-17-2008, 12:31 PM
WinteE There's a topic about... 09-17-2008, 12:54 PM
  1. #1
    Registered User
    Join Date
    09-17-2008
    Location
    Lincoln, NE
    Posts
    1

    conditional formatting?

    I have an spreadsheet that I created. I entered a simple formula in one of the cells basically =(B2/B3). I was wondering if anyone could give me direction on how I could change the color of that cell value if it is greater than certain conditions. For instance...if my reference cells are "making" and "2.31", and the formula above gives me a result greater than the 2.31, it would change the number to say red.
    So on one line of my spreadsheet, I am recording the activity "making", and then the times and amount produced for making which gives me "2.31". I want that cell to turn to red if the value is greater than "2.31".

    thanks for any help

  2. #2
    Forum Contributor WinteE's Avatar
    Join Date
    04-07-2007
    Location
    Netherlands
    Posts
    544
    There's a topic about conditional format on my site.

    Erik
    Just keep it simple !


    http://www.excelguide.eu
    In English as well as in Dutch

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Excel 2007 : Conditional Formatting drag
    By Scott27 in forum Excel General
    Replies: 3
    Last Post: 04-25-2013, 09:15 AM
  2. Conditional formatting with VB
    By crizzle in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 06-30-2008, 01:26 PM
  3. Excel 2007 conditional formatting bug
    By jmessina in forum Excel General
    Replies: 0
    Last Post: 04-28-2008, 09:09 AM
  4. Replies: 1
    Last Post: 06-27-2007, 06:19 PM
  5. Conditional formatting macro (highlight macro)
    By c991257 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-09-2007, 02:46 PM

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