Data Validation with a Formula

[lewis94]

Hi All,

Any help would be appreciated as this is driving me up the wall.

I have three cells E17, F17, G17 that use a conditional format to display a tick/cross. F17 is a dummy cell that uses an If/Or statement to display "0" based on the contents of E17 and G17

I want to use a data validation Stop command if the input for E17 or G17 is the same, ie "1". I want either E17=1 or G17=1 not both.

Tried numerous attempts but not achieved what I am after

 

[mole999]

not really a stop command =IF(OR(E17=1,G17=1 etc. To make sure that both don't contain 1 then you will need and AND so IF(AND(E17=1,G17=1 result then build in the OR to be evaluated > https://www.ablebits.com/office-addins-blog/2014/12/17/excel-and-or-xor-not-functions/