Conditional Formatting a Fraction??

[dgaletar]

Hello again! I am trying to use conditional formatting to highlight a cell in yellow with bold black text where the value is less than 5/32 of an inch, orange text if it falls between 5/32 and 7/32, and bold green text if it is over 7/32.

Anybody???

[FDibbins]

1. highlight the range you want to apply the conditional formatting to
2. on the home tab, styles, select CF
3. select new rule, select use formula
4. enter =AND(E1>0,E1<5/32) format fill Yellow/Black

Repeat 3 and 4...
=E1>=5/32 formay fill Orange

repeat 3 and 4...
=E1>7/32 format fill GREEN

[newdoverman]

These three rules should accomplish what you want.
Select the cells that you want conditionally formatted. I used column A. Go to Conditional Formatting, New Rule, Use Formula... and enter these formula and apply the appropriate formatting.

1. =AND(A1<>"",A1<5/32)

2. =AND(A1<>"",A1>4/32,A1<8/32)

3. =AND(A1<>"",A1>7/32)

[dgaletar]

Thanks FDibbins, but the orange didn't work. Doesn't it need to be something like greater than 4/32 but less than 7/32? [Maybe... =AND(E1>4/32,E1<7/32) ?]

[FDibbins]

oops forgot to say to check the "Stop if True" box

[dgaletar]

Got it. They work great! Thank you both!!!

DG

[FDibbins]

Happy to help, thanks for the feedback