Highlighting cells formula

[Soeril]

Problem post below(added attachment)

[Soeril]

Hello all,

I have a problem with creating formula which will highlight cells.

It should work something like this.
EXAMPLE

Destination cell is: =Pirate!B2
This cell should be highlighted if the value will be found in other sheet ex. Requests A1:A50
If the value will be found it should be highlighted in any colour to alert.

So the C2 field in "Do tabeli" should search exact number in sheet Request, if found it should return with the colour field in "Do tabeli". C2 can't be a flat value.


I tried used conditional formatting but excel returns me with "change the reference to a single cell" message.


Any ideas if this could be done?


Waiting for any suggestions.

Thank You in advance!