+ Reply to Thread
Results 1 to 2 of 2

Conditional formating

  1. #1
    Forum Contributor
    Join Date
    09-15-2011
    Location
    London
    MS-Off Ver
    Excel 2016
    Posts
    135

    Conditional formating

    Hi Experts,

    I have a query in the conditional format how can i refer and get the data from combining three values have mentioned three columns A,B,C and also the result will come in the D1 cell as i have said G1 cell in the I to J Column.

    Kindly assist
    Raju
    Attached Files Attached Files

  2. #2
    Forum Expert etaf's Avatar
    Join Date
    10-22-2004
    Location
    Wittering, West Sussex, UK
    MS-Off Ver
    365 (Mac OSX) (16.84 (24041420))
    Posts
    8,751

    Re: Conditional formating

    you will need to setup three rules for each colour

    Can you clarify column B ,as that seems to have the same rule for yellow and green

    heres is the rules setup
    and the rules are shown in G8 > J11
    Attached Files Attached Files
    Wayne
    if my assistance has helped, and only if you wish to , there is an "* Add Reputation" on the left hand side - you can add to my reputation here

    If you have a solution to your thread - Please mark your thread solved do the following: >
    Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

+ 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. Conditional formating based on other conditional formating?
    By OldManExcellor in forum Excel General
    Replies: 11
    Last Post: 09-14-2014, 02:20 PM
  2. Replies: 5
    Last Post: 03-14-2014, 04:03 AM
  3. Replies: 4
    Last Post: 01-23-2014, 10:14 AM
  4. Conditional formating-What formula do i need to use in conditional formating
    By warrima in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-07-2009, 12:33 AM
  5. Replies: 6
    Last Post: 08-14-2006, 05:00 PM
  6. Replies: 2
    Last Post: 03-27-2006, 12:10 PM
  7. Install dates formating using conditional formating?
    By Jerry Eggleston in forum Excel General
    Replies: 2
    Last Post: 11-09-2005, 01:49 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