Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
conditional format on first & last digit on 3 digit cell data
How to create conditional formatting and color shade cells which contains the
first and last digit which I'm looking at regardless of any order on three digit cell data? |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
conditional format on first & last digit on 3 digit cell data
Use a formula of
=AND(LEFT(A2,1)="5",RIGHT(A2,1)="7") as an example -- __________________________________ HTH Bob "caprey" wrote in message ... How to create conditional formatting and color shade cells which contains the first and last digit which I'm looking at regardless of any order on three digit cell data? |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
conditional format of adjacent cell with different range and crite
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. A 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 equal to less than 75,with fill effects blue and blue font.Mondays values equal to less than 45,with fill effects green and green font.so on. Can you please suggest me any solution for such case. Regards Rupesh |
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
conditional format of adjacent cell with different range and crite
Use CF formulae of
=AND(A:A="Saturday,B:B<50) etc. -- __________________________________ HTH Bob "icsonu" wrote in message ... 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. A 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 equal to less than 75,with fill effects blue and blue font.Mondays values equal to less than 45,with fill effects green and green font.so on. Can you please suggest me any solution for such case. Regards Rupesh |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Format 2 digit year to 4 digit | Excel Discussion (Misc queries) | |||
Color a single digit in a mult-digit number cell | Excel Discussion (Misc queries) | |||
Tell users how to sort 5 digit and 9 digit zipcodes correctly aft. | New Users to Excel | |||
16 DIGIT NUMBERS IN CELL WITHOUT LAST DIGIT BEING A ZERO | Excel Worksheet Functions | |||
When we enter a 16 digit number (credit card) the last digit chan. | Excel Discussion (Misc queries) |