Conditional formatting!
 

I am not fluent in excel, and any help would he highly appreaciated.

Column and Row D3 -D20 contains only the following values Writ or Verb.
Column e - K with rows 3 - 20 will contain values such as Yes or No or N/A.
What I need to do is make sure that if column/Row D3 says Verb then it will
be automatic for the following columns to have N/A in it - column J3 and K3
will have N/A.
If the column/Row D3 says Writ then Column H3 will automatically have N/A

Conditional formatting!
 

I am not sure exactly what you are looking for. But it seems that you
should use a IF statement in the columns

=IF(D3="Verb", "N/A", "")

or

=IF(D3="Write", "N/A", "")

Put this in the cell that needs it


--
Bearacade


------------------------------------------------------------------------
Bearacade's Profile: http://www.excelforum.com/member.php...o&userid=35016
View this thread: http://www.excelforum.com/showthread...hreadid=553713

Conditional formatting!
 

In cell H3 put this formula and copy it down column H.........

=IF($D3="writ","N/A","")

IN cells J3 and K3 put this formula and copy it down those columns

=IF($D3="verb","N/A","")

Vaya con Dios,
Chuck, CABGx3



"JOM" wrote:

I am not fluent in excel, and any help would he highly appreaciated.

Column and Row D3 -D20 contains only the following values Writ or Verb.
Column e - K with rows 3 - 20 will contain values such as Yes or No or N/A.
What I need to do is make sure that if column/Row D3 says Verb then it will
be automatic for the following columns to have N/A in it - column J3 and K3
will have N/A.
If the column/Row D3 says Writ then Column H3 will automatically have N/A

Conditional formatting!
 

Ok for the if statment you have provided, if D3 is Verb then enter N/A
otherwise enter yes or No how will I satisfy the otherwise condition

"Bearacade" wrote:


I am not sure exactly what you are looking for. But it seems that you
should use a IF statement in the columns

=IF(D3="Verb", "N/A", "")

or

=IF(D3="Write", "N/A", "")

Put this in the cell that needs it


--
Bearacade


------------------------------------------------------------------------
Bearacade's Profile: http://www.excelforum.com/member.php...o&userid=35016
View this thread: http://www.excelforum.com/showthread...hreadid=553713

Conditional formatting!
 

What is the Yes or No based on?


--
Bearacade


------------------------------------------------------------------------
Bearacade's Profile: http://www.excelforum.com/member.php...o&userid=35016
View this thread: http://www.excelforum.com/showthread...hreadid=553713

Conditional formatting!
 

Yes/No or N/A are the the only choices that I would like the user to enter,
N/A will be only choice if D3 is Verb otherwise the user can enter Yes or No.

"Bearacade" wrote:


What is the Yes or No based on?


--
Bearacade


------------------------------------------------------------------------
Bearacade's Profile: http://www.excelforum.com/member.php...o&userid=35016
View this thread: http://www.excelforum.com/showthread...hreadid=553713