Results 1 to 3 of 3

Thread: Conditional Formatting using formula.

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. #1
    Member Ryan_Bernal's Avatar
    Join Date
    Dec 2012
    Posts
    37
    Rep Power
    0

    Conditional Formatting using formula.

    Hello guys.
    Good Day!
    This is in relation with my previous post.
    http://www.excelfox.com/forum/f2/fil...cal-value-794/

    My problem is.
    How to format cells with this condition.
    1. format the cells with green color from the first inputed cell till B6 will be reach
    2. any value that will be inputted beyond the green line will be filled with red
    Her is my workbook.
    Attached Files Attached Files

Similar Threads

  1. Get Displayed Cell Color (whether from Conditional Formatting or not)
    By Rick Rothstein in forum Rick Rothstein's Corner
    Replies: 14
    Last Post: 10-21-2013, 07:11 PM
  2. Conditional formatting
    By mahmoud-lee in forum Excel Help
    Replies: 9
    Last Post: 05-30-2013, 03:00 PM
  3. Conditional Formatting - If/And Formula
    By Katrina in forum Excel Help
    Replies: 4
    Last Post: 11-23-2012, 12:45 AM
  4. Replies: 2
    Last Post: 09-16-2012, 02:28 AM
  5. Replies: 4
    Last Post: 07-17-2012, 12:49 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •