kccarson002
New Member
- Joined
- Feb 6, 2018
- Messages
- 3
Hi there,
What I am trying to do is conditionally format a comments column based on what control code is used. so that if a certain project code is used the comments column turns red UNTIL IT IS FILLED OUT. Once the comments section is filled out correctly it should go back to the regular color. If the control code used is a non- project code the comments column should grey out.
I am using a drop down box for the control codes that is on another tab in the workbook. Please help! I know it has something do with conditional formatting with formulas but I am uncertain which should be used.
[TABLE="width: 1604"]
<tbody>[TR]
[TD]Month[/TD]
[TD]Day[/TD]
[TD]Control
Code[/TD]
[TD]Activity[/TD]
[TD]Minutes[/TD]
[TD]Hours[/TD]
[TD]Work
Type [/TD]
[TD]Auditor[/TD]
[TD]Advise / Consultation Project [/TD]
[TD]Comments[/TD]
[/TR]
[TR]
[TD]01 - January[/TD]
[TD]1[/TD]
[TD]5 - Holiday[/TD]
[TD]Holiday[/TD]
[TD]480[/TD]
[TD]8.0[/TD]
[TD] [/TD]
[TD]Joe[/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
</tbody><colgroup><col><col><col><col><col><col><col span="2"><col><col></colgroup>[/TABLE]
What I am trying to do is conditionally format a comments column based on what control code is used. so that if a certain project code is used the comments column turns red UNTIL IT IS FILLED OUT. Once the comments section is filled out correctly it should go back to the regular color. If the control code used is a non- project code the comments column should grey out.
I am using a drop down box for the control codes that is on another tab in the workbook. Please help! I know it has something do with conditional formatting with formulas but I am uncertain which should be used.
[TABLE="width: 1604"]
<tbody>[TR]
[TD]Month[/TD]
[TD]Day[/TD]
[TD]Control
Code[/TD]
[TD]Activity[/TD]
[TD]Minutes[/TD]
[TD]Hours[/TD]
[TD]Work
Type [/TD]
[TD]Auditor[/TD]
[TD]Advise / Consultation Project [/TD]
[TD]Comments[/TD]
[/TR]
[TR]
[TD]01 - January[/TD]
[TD]1[/TD]
[TD]5 - Holiday[/TD]
[TD]Holiday[/TD]
[TD]480[/TD]
[TD]8.0[/TD]
[TD] [/TD]
[TD]Joe[/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
</tbody><colgroup><col><col><col><col><col><col><col span="2"><col><col></colgroup>[/TABLE]