Excel 2003 Conditional Formatting w/ 3 Conditions and a value = to

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 ;-)
 
L

Luke M

The easier way might be to use Data Validation. Select cells f5:i5. Go to
Data - Validation. From first dropdown, select custom. input this formula:
=COUNTA($C5)=1
Hit ok.

Now, you can only input something into f5:i5 (and thus trigger your
formatting) if C5 is filled in.
 
G

Glenn

Enggal said:
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 ;-)


Try something like this:

=AND($C5="x", 'your current conditional format formula' )
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top