Conditionally format IF, ISNUMBER, MATCH

[mpendle]

Hi,

Please refer to the attached document.
I wish to try and conditionally format Sheet1!D:D depending on if Sheet2!E:E displays a particular letter, when;
Matching Sheet1!A:A to Sheet2!A:A
Matching Sheet1!B:B if <11 to Sheet2!B:B where cell equals text "Small (7-10)" if Sheet1!B:B is >10 then where Sheet2!B:B equals text "Mid - Large (11-16)"
Matching Sheet1!C:C if cell contains "Hcap" to Sheet2!C:C where cell equals "Handicaps". If Sheet1!C:C doesnt contain "Hcap" match to Sheet2!C:C where cell equals "All Races".

To use an example, if E:E in the cell adjacent to all the matches above equals N then the cell in Sheet1!D:D turns red. Cell D52 would become red.
D88, D91, D92, D93 and D96 would also become red.

Here was my attempt at the formula, no idea if I was close to the answer.

Please Login or Register  to view this content.

Many thanks in advance for your help.

[NBVC]

Haven't really tested it, but your formula might need to look more like this:

Please Login or Register  to view this content.

Which you should put in an adjacent column.. and confirm with CTRL+SHIFT+ENTER as it is an array formula.....

Then you can base your condition on whether this result is TRUE or FALSE

[mpendle]

Thankyou for your help, that has sent me in the right direction.