hello there, need help how to allow enter in two cells only one respond - data validation and conditional formatting. - see the attached file. one one respond should be accepted and color changed from red to green. the second respond should be denied.
in B4 use a custom validation
=AND($B4=1,$C4="")
in C4
=AND($C4=1,$B4="")
same thing for the other cells
B7
=AND($B7=1,$C7="",$D7="",$E7="",$F7="",$G7="",$H7="")
C7
=AND($B7="",$C7=1,$D7="",$E7="",$F7="",$G7="",$H7="")
D7
=AND($B7="",$C7="",$D7=1,$E7="",$F7="",$G7="",$H7="")
E7
=AND($B7="",$C7="",$D7="",$E7=1,$F7="",$G7="",$H7="")
F7
=AND($B7="",$C7="",$D7="",$E7="",$F7=1,$G7="",$H7="")
G7
=AND($B7="",$C7="",$D7="",$E7="",$F7="",$G7=1,$H7="")
H7
=AND($B7="",$C7="",$D7="",$E7="",$F7="",$G7="",$H7=1)
I'm sure there may be away to do this with one formula selecting the range
but thats all i could do
also Untick - ignore BLANK
Wayne
if my assistance has helped, and only if you wish to , there is an "* Add Reputation" on the left hand side - you can add to my reputation here
If you have a solution to your thread - Please mark your thread solved do the following: >
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks