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
|