Custom Data Validation

[mukeshnic]

I've one of the following values in Column 'A' :

Final Term Accepted
Final Term Declined
Share Draft
Share Advised
Share Declined
Share Accepted
Bound

I want to restrict data entry in column 'B' if value in Column 'A' is not "Final Term Declined"

Please advise custom validation formula. Thanks in advance

 

[Mike_VBA]

I've one of the following values in Column 'A' :

Final Term Accepted
Final Term Declined
Share Draft
Share Advised
Share Declined
Share Accepted
Bound

I want to restrict data entry in column 'B' if value in Column 'A' is not "Final Term Declined"

Please advise custom validation formula. Thanks in advance

Use :

=IF($A1<>"Final Term Declined","True","False")

 

[Osvaldo Palmeiro]

Hi

Highlight column B<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>
Data / Validation / Formula:<o></o>
=A1="Final Term Declined"

<o></o>

 

[Mike_VBA]

Hi

Highlight column B<o></o>
Data / Validation / Formula:<o></o>
=A1="Final Term Declined"

<o></o>

Oh.. My bad.. what I gave works in reverse.. !