Conditional Fomatting Formular

[karmaimages]

I have the current formular

=COUNTA(INDIRECT("'Team Manager'!$i$11:$i$19"))<9
Make cell red

I want to add another that is <9 but >1 cell is orange

Any ides how this could be done?

 

[Gerald Higgins]

Perhaps

=and(COUNTA(INDIRECT("'Team Manager'!$i$11:$i$19"))< 9,
COUNTA(INDIRECT("'Team Manager'!$i$11:$i$19"))> 1

But this needs to be your FIRST condition.
The plain check for less than 9 needs to become your second condition.

 

[karmaimages]

Perhaps

=and(COUNTA(INDIRECT("'Team Manager'!$i$11:$i$19"))< 9,
COUNTA(INDIRECT("'Team Manager'!$i$11:$i$19"))> 1

But this needs to be your FIRST condition.
The plain check for less than 9 needs to become your second condition.

Would that be entered as one line of code?

 

[karmaimages]

The Current Formular's i have are as follows, should have put them from the start:


1. =COUNTA(INDIRECT("'Team Manager'!$i$11:$i$19"))<9
Turn Cell Red
2. =COUNTA(INDIRECT("'Team Manager'!$i$11:$i$19"))=9
Turn Cell Green

Thanks

 

[Gerald Higgins]

Yes, it's one line of code.

If I understand you correctly . . .
Your new condition needs to be condition 1.
Your old condition 1 needs to become condition 2.
Your old condition 2 needs to become condition 3.

 

[karmaimages]

Yes, it's one line of code.

If I understand you correctly . . .
Your new condition needs to be condition 1.
Your old condition 1 needs to become condition 2.
Your old condition 2 needs to become condition 3.

I type in the formula and keep getting the error message that it is missing a parenthesis --) or (.

Any Idea?

Thanks for your reply

 

[Gerald Higgins]

Sorry, you're right, my fault.
Put another closing bracket
)
at the very end of the formula. That should do it.

 

[StuLux]

Already answered