View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
JOM
 
Posts: n/a
Default 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