E
Enggal
I am trying to create a red green amber format only if a condition is checked
as required.
For example.
Cells C5:E5 asks if that line item is a required item for this program.
Marking cell C5 with an "x" would indicate that is a required item and thus
needs more cells to be completed (f5:I5) that describe the state/progress of
that item. Marking either Cell D5 or E5 would not require any further entries
and cells f5:i5 should remain blank (no formatting).
Cells F5:I5 are inputs that correspond to the line item & once one evaluates
the task---then they enter a number...if the number they enter to those cells
is 5--then it would be green, 4 & 3 are amber & 1&2 are red.
I can get the 3 colors to work w/out issue...however, am having a hard time
making sure thatthe conditional formatting only comes into play when the cell
C5 is marked & otherwise---there is no formatting at all.
Thanks in advance for the help ;-)
as required.
For example.
Cells C5:E5 asks if that line item is a required item for this program.
Marking cell C5 with an "x" would indicate that is a required item and thus
needs more cells to be completed (f5:I5) that describe the state/progress of
that item. Marking either Cell D5 or E5 would not require any further entries
and cells f5:i5 should remain blank (no formatting).
Cells F5:I5 are inputs that correspond to the line item & once one evaluates
the task---then they enter a number...if the number they enter to those cells
is 5--then it would be green, 4 & 3 are amber & 1&2 are red.
I can get the 3 colors to work w/out issue...however, am having a hard time
making sure thatthe conditional formatting only comes into play when the cell
C5 is marked & otherwise---there is no formatting at all.
Thanks in advance for the help ;-)