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?