Conditional Formatting with Several Conditions

[Brittropp07]

Good Morning,
How can you create conditional formatting with several conditions? For example..

GRADE

ON 200 MESH

<colgroup><col span="7"></colgroup><tbody>
</tbody>

20EXT24 15
20EXT24 32
ULD 14
ULD 24

I am trying to show values that do not meet specification,The specification is 20EXT24 <30 and ULD Between 15-25? How do I show the values that have a specific text in column A should color red is values that are not in specification?

Thank you!

 

[Joe4]

Welcome to the Board!

Use the Formula option in Conditional Formatting, and use the AND function, i.e.

=AND(condition 1, condition 2, ...)

 

[etaf]

i assume the numbers at the end can be 1,2 or more digits ?
But should always start 9th character in the case of 20EXT24
and 5th for ULD

then you could extract the values and use that as conditional formatting - let me try and post back
But can you confirm the assumption is correct

This will work for 20EXT24
=AND(LEFT(A1,7)="20EXT24", MID(A1,9,5)*1>30)

=AND(LEFT(A1,3)="ULD", OR(MID(A1,5,3)*1>25,MID(A1,5,3)*1<15))

for 2007, 2010 or 2013 excel version
Conditional Formatting


Highlight applicable range >>

A:A



Home Tab >> Styles >> Conditional Formatting
New Rule >> Use a formula to determine which cells to format
Edit the Rule Description: Format values where this formula is true:



=AND(LEFT(A1,7)="20EXT24", MID(A1,9,5)*1>30)



Format… [Number, Font, Border, Fill]
choose the format you would like to apply when the condition is true
OK >> OK

Repeat for other formula

 

[Special-K99]

Ignore this post, misread the requirements.