# IF CONDITIONAL FORMATTING

#### Samgraphics

##### New Member
I'M TRYING TO CREATE AN IF CONDITIONAL FORMATTING FOR THIS

WHAT I'M TRYING TO DO IS THIS, SEE SCREENGRAB. I'M TRYING TO GROUP COMBINATIONS OF NUMBERS INTO HIGH/LOW ODD/EVEN SETS
NUMBERS THAT ARE LOWER THAN 10 ARE "LOW LOW + ODD/EVEN"
GREATER THAN 10 BUT LESS THAN 18 ARE "HIGH LOW + ODD/EVEN"
GREATER THAN 18 BUT LESS THAN 27 ARE "LOW HIGH + ODD/EVEN"
AND GREATER THAN 27 ARE "HIGH HIGH + ODD/EVEN"
I'VE COME UP WITH THESE TWO OPTIONS. THE FIRST ONE IS ONLY GIVING ME HALF OF WHAT I WANT. IT GETS THE "LOW LOW" AND THE "HIGH LOW"
=IF(C2>\$AF\$3,"HIGH","LOW")&" "&IF(C2>\$AF\$2,"HIGH","LOW")&" " & IF(ISODD(C2),"ODD","EVEN")

THIS ONE IS GETTING ME 3/4 OF THE WAY
=IF(AND(C2>\$AF\$3,C2>\$AF\$2,C2>\$AF\$4),"HIGH","LOW")&" "&IF(OR(AND(C2>\$AF\$3),(C2>\$AF\$2),(C2>\$AF\$4)),"HIGH","LOW")&" " & IF(ISODD(C2),"ODD","EVEN")

I ALSO TRIED THIS BUT IT'S ONLY GETTING ME 3 OF THE CORRECT RESULTS
=IF(OR(C2<\$AF\$2,C2<\$AF\$3,C2<\$AF\$4),"LOW","HIGH")&" "&IF(OR(C2>\$AF\$2,C2>\$AF\$3,C2>\$AF\$4),"HIGH","LOW")&" " & IF(ISODD(C2),"ODD","EVEN")

BUT I'M COMPLETELY LOST AFTER THAT

THANK YOU SO MUCH

#### Attachments

• Screen Shot 2022-01-22 at 3.30.13 PM.jpg
44.6 KB · Views: 6
• Screen Shot 2022-01-23 at 10.12.27 AM.jpg
37.5 KB · Views: 5

### Excel Facts

Waterfall charts in Excel?
Office 365 customers have access to Waterfall charts since late 2016. They were added to Excel 2019.
Another way:

Cell Formulas
RangeFormula
D2:D9D2=IF(C2>\$AF\$4,"HIGH HIGH",IF(C2>\$AF\$2,"LOW HIGH",IF(C2>\$AF\$3,"HIGH LOW","LOW LOW"))) & IF(ISODD(C2)," ODD"," EVEN")
E2:E9E2=IF(AND(C2>\$AF\$4,ISODD(C2)),"HIGH HIGH ODD",IF(AND(C2>\$AF\$2,ISODD(C2)),"LOW HIGH ODD",IF(AND(C2>\$AF\$3,ISODD(C2)),"HIGH LOW ODD",IF(AND(C2>\$AF\$4,ISEVEN(C2)),"HIGH HIGH EVEN",IF(AND(C2>\$AF\$2,ISEVEN(C2)),"LOW HIGH EVEN",IF(AND(C2>\$AF\$3,ISEVEN(C2)),"HIGH LOW EVEN",IF(AND(C2<\$AF\$2,ISEVEN(C2)),"LOW LOW EVEN","LOW LOW ODD")))))))

Hi, sorry for multiple post.

Although the above two methods will show the correct output. If you are using Excel 2019 or Excel 365, you can use below If statement:

Excel Formula:
``=IFS(AND(C2>\$AF\$4,ISODD(C2)),"HIGH HIGH ODD",AND(C2>\$AF\$2,ISODD(C2)),"LOW HIGH ODD",AND(C2>\$AF\$3,ISODD(C2)),"HIGH LOW ODD",AND(C2>\$AF\$4,ISEVEN(C2)),"HIGH HIGH EVEN",AND(C2>\$AF\$2,ISEVEN(C2)),"LOW HIGH EVEN",AND(C2>\$AF\$3,ISEVEN(C2)),"HIGH LOW EVEN",AND(C2<\$AF\$2,ISEVEN(C2)),"LOW LOW EVEN",AND(C2<\$AF\$2,ISODD(C2)),"LOW LOW ODD")``

Hi, sorry for multiple post.

Although the above two methods will show the correct output. If you are using Excel 2019 or Excel 365, you can use below If statement:

Excel Formula:
``=IFS(AND(C2>\$AF\$4,ISODD(C2)),"HIGH HIGH ODD",AND(C2>\$AF\$2,ISODD(C2)),"LOW HIGH ODD",AND(C2>\$AF\$3,ISODD(C2)),"HIGH LOW ODD",AND(C2>\$AF\$4,ISEVEN(C2)),"HIGH HIGH EVEN",AND(C2>\$AF\$2,ISEVEN(C2)),"LOW HIGH EVEN",AND(C2>\$AF\$3,ISEVEN(C2)),"HIGH LOW EVEN",AND(C2<\$AF\$2,ISEVEN(C2)),"LOW LOW EVEN",AND(C2<\$AF\$2,ISODD(C2)),"LOW LOW ODD")``
HI not at all, thank you so much for the quick reply and the solutions. They all work perfectly, well except for the last one because I'm on excel 2011, but the other's are working great.

I'm such an idiot, it never occurred to me to just put the two words together like you did, instead I'm trying to concatenate them in the formula. man I'm dumb. ?

Replies
1
Views
114
Replies
1
Views
64
Replies
18
Views
220
Replies
3
Views
130
Replies
17
Views
130

1,203,635
Messages
6,056,464
Members
444,866
Latest member
cr130

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back