Home |
Search |
Today's Posts |
#1
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. 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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional Format for one cell based on range | Excel Worksheet Functions | |||
Copying a range adjacent to Conditional Format - CF Rule adds to P | Excel Discussion (Misc queries) | |||
Conditional format a cell based on another range of cells | Excel Worksheet Functions | |||
Using SUMIF Function with a named cell reference as value in CRITE | Excel Worksheet Functions | |||
Conditional Format - Formula to Colour Every 3rd Cell in Offset Range | Excel Discussion (Misc queries) |