Can anyone please help...
I want to input a name into cell A1
For B1 I would like to use the IF funtion so that,
If the text in A1 = "Dave" OR "John" for B1 to display "Y" otherwise display "N" and for the "N" to be red coloured font, if that's possible.
Many thanks,
Irfan
I want to input a name into cell A1
For B1 I would like to use the IF funtion so that,
If the text in A1 = "Dave" OR "John" for B1 to display "Y" otherwise display "N" and for the "N" to be red coloured font, if that's possible.
Many thanks,
Irfan