Conditional formatting!

J

JOM

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
 
B

Bearacade

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
 
C

CLR

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
 
J

JOM

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
 
J

JOM

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.
 
Top