GeorgeCunn
New Member
- Joined
- Jun 21, 2017
- Messages
- 10
If I enter a "Y" in B7, I want it to automatically enter a 0 in B9 using conditional formatting.
I tried using this formula (in conditional formatting) but it didn't work.
=if(B7="Y",0,"") I also tried if(B7="Y",0,0) Unfortunately neither worked.
As an option, if a "Y" was entered in B7, then it would automatically delete the contents in B9.
Thanking you in advance for your help.
I tried using this formula (in conditional formatting) but it didn't work.
=if(B7="Y",0,"") I also tried if(B7="Y",0,0) Unfortunately neither worked.
As an option, if a "Y" was entered in B7, then it would automatically delete the contents in B9.
Thanking you in advance for your help.