conditional format of adjacent cell with different range and crite

[icsonu]

Well I have to Conditional format a range of values of range of string
character. For Eg. Column A contains Weekdays, 5 Mondays,3 Tuesdays, 2
Wednesday, 7 Thursday, 2 Friday, 3 Saturday and 6 Sunday in Column A. With
having range of values from 30 to 100 in the adjacent cells of Column A.
Col A Col B
Sunday 32
Sunday 65
Sunday 52
Sunday 69
Sunday 45
Sunday 85
Monday 63
Monday 25
Monday 36
Monday 41
Monday 48
Tuesday 95
Tuesday 74
Tuesday 56
Wednesday 15
Wednesday 45
Thursday 49
Thursday 87
Thursday 16
Thursday 53
Thursday 23
Thursday 29
Thursday 21
Friday 54
Friday 63
Saturday 45
Saturday 76
Saturday 33
Now i want conditional format Saturday Values equal to less than 50,with
fill effects red and red font.
Sunday Values Values equal to less than 75,with fill effects blue and blue
font.Mondays alues equal to less than 45,with fill effects green and green
font.so on.
Can you please suggest me any solution for such case.

 

[Luke M]

In cell B2, conditional format formulas
condition1
=AND(A2="Saturday",B2<=50)
condition2
=AND(A2="Sunday",B2<=75)
condition3
=AND(A2="Monday",B2<=45)
Set your formatting how you want.
Then copy and paste special formatting to the other cells in column B.

Note that in XL 2003 and older you can only have 3 conditions.