Conditional formatting based on (x,y) data values

[huli601]

Hi,

Can you help me with conditional formattting. I want to color cells. I have 2 sheets ("Sheet1" and "Rezervacia"). In Sheet1 I have table like this (red rectangles are rows and columns where I (find) choose values):

this is sheet "Rezervacia" where I enter values for "dlzka" and "box". I enter following values:

and finaly this is result I expect:

 

[MarcelBeug]

Format the list on sheet Recervacia as table, e.g. "Table1".
Define names:
dlzka_rec =Table1[dlzka]
box_rec = Table1[box]

Now select your data range for conditional formatting (e.g. B3:R100), go to conditional formatting - new rule - based on formula - formula

=COUNTIFS(dlzka_rec,B$2,box_rec,$A3)

and format with fill color red.

 

[huli601]

Thank you very very much!