+ Reply to Thread
Results 1 to 3 of 3

conditional formatting:change the cell color based on based on inputs in another column

  1. #1
    Registered User
    Join Date
    07-25-2009
    Location
    india
    MS-Off Ver
    Excel 2016
    Posts
    41

    conditional formatting:change the cell color based on based on inputs in another column

    Need help in conditional formatting. Need to change the actuals colour based on percentage completion.
    Based on completion % in K3 corresponding G3 column should be rated as Red , Amber orgreen (if <50% -red . Between 50-95% - Amber, >95% - Green. how can I do this in condtional formating. Then I need to extend the same for K4- K7. similarly based on L3 , H3 to be marked as red, Amber , green then same to be applied for L4 - L7
    Attached Files Attached Files

  2. #2
    Registered User
    Join Date
    03-01-2012
    Location
    Chennai, India
    MS-Off Ver
    Excel 2007
    Posts
    3

    Re: conditional formatting:change the cell color based on based on inputs in another colum

    Check if this helps.
    Attached Files Attached Files

  3. #3
    Valued Forum Contributor jtakw's Avatar
    Join Date
    05-05-2018
    Location
    CA, USA
    MS-Off Ver
    2016
    Posts
    668

    Re: conditional formatting:change the cell color based on based on inputs in another colum

    Hi,

    Based on your written description, just one small correction to CF formulas provided above.

    For Amber: =K3<=0.95

+ 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. Replies: 5
    Last Post: 12-07-2013, 02:21 PM
  2. Replies: 3
    Last Post: 11-08-2013, 03:10 PM
  3. Replies: 10
    Last Post: 06-19-2013, 05:28 PM
  4. [SOLVED] 2010 Conditional Formatting: Cell Color Change, Based on Ratio (1:1)
    By James_D in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 01-29-2013, 09:02 PM
  5. [SOLVED] Conditional Formatting Entire Rows based on Change in Cell Value in Column A
    By Etain in forum Excel Formulas & Functions
    Replies: 26
    Last Post: 09-26-2012, 07:31 AM
  6. Replies: 5
    Last Post: 05-10-2012, 10:49 PM
  7. Replies: 6
    Last Post: 03-20-2012, 12:08 AM

Tags for this Thread

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