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