More than 3 Conditions???

  • Thread starter Thread starter gib21
  • Start date Start date
G

gib21

I currently have 3 conditions for a column of cells, as an example;
Condition 1 Format is Red =OR(B10=2,AE10="Yes") AE10 is 'Yes/No' dropdown
Condition 2 Format is 'No Colour' =AE10="No"
Condition 3 Format is 'Green' =B10=1
I need Condition 4 to be 'Orange' with the formula as =B10=2
I have '=COUNTA(AC7,AD7,AE7,AH7)' in column B.
Can anyone help?
 
Hi,
The problem with what you want to achieve is that you have already give a
condition to cell B10=2 (Condition 1). you stablish you wanted to be red

If this was helpful, please click yes, thanks
 
Sorry 'B10=3' should format to Orange!!

Eduardo said:
Hi,
The problem with what you want to achieve is that you have already give a
condition to cell B10=2 (Condition 1). you stablish you wanted to be red

If this was helpful, please click yes, thanks
Click to expand...
 
Hi,
go to conditional formation, where the formula is and enter there
B10=3
select you color to orange
 
That is my point,

i already have 3 Conditions, i cannot just 'enter there & select colour to
orange'

there is no option for this!
 
Can you not ignore condition 2? Format the column as no color. Then, if
AE10="No", it wouldn't change, so no need for that conditional format, and
you'd have 3 to use.

Please note, you can only have 3 conditions, so there is no way to perform a
4th.
 
If i ignore condition 2 the data validation 'Yes/No' (column AE) changes to
orange because a 3rd cell is populated with no format unless there is a
formula to ignore Condition 1 if 'No' is selected!
 
Try
cond1 =B10=1
cond2 =B10=3
cond3 =AND(B10=2,AE10="Yes")

You will get the default color if AE10 is "No" or has a value other than 1,
2 or 3.
 
That would bring us back to the 3 is your limit issue.

In that case, you'll need some Visual Basic code. May want to ask in the
programming section to see fi they can give you some nice code to use to
accomplish this.
 
Back
Top