Results 1 to 6 of 6

Thread: Conditional formatting based on (x,y) data values

  1. #1

    Conditional formatting based on (x,y) data values

    Register for a FREE account, and/
    or Log in to avoid these ads!


    Can you help me with conditional formattting. I have 2 sheets. In Sheet1 I have table like this:

    ___4 _ 5 _ 6 _ SC4 . . ._______
    1b ___45 __________________
    2b _______6 ________________
    3b 14_56_____ 5____________
    4b ____9_____12____________
    5b ____1_____34____________
    In Sheet2 I enter values: 4 , 3b
    _____________________ 5 , 4b

    I want change color for cells (4,3b) (cell with number "14" change color)
    ________________________ (5,4b) (cell with number "9" change color)
    I can find values of this cells due function INDEX but how can I change color of this cells?
    Last edited by huli601; 2015-10-24 at 07:08 AM.

  2. #2
    Magician navic's Avatar
    Join Date
    Aug 2013
    Europe, Croatia
    Excel Version
    Excel 2013
    Quote Originally Posted by huli601 View Post
    Can you help me with conditional formattting. I have 2 sheets.
    Please, can you set a example of your file and you enter the expected result
    My personal Web Excel Tutorials
    Attention! In the formulas as a delimiter I use a semicolon (; ) if you using my formula, then perhaps you need to use a comma (,)
    Also for a decimal number I use a comma (,) you may need to use point (.) instead of

  3. #3
    sorry for spam, I need three more post to insert images

  4. #4

  5. #5
    I delete after final post all of this posts

  6. #6
    this is the table where I want format color of cells:

    this is Sheet3 named "Rezervacie" where I enter values for "dlzka" and "box". I enter following values:

    and finaly this is result I expect:

    Attached Thumbnails Attached Thumbnails Click image for larger version. 

Name:	2.jpg 
Views:	8 
Size:	40.2 KB 
ID:	4060  

Tags for this Thread

Posting Permissions

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