S Steve Mar 11, 2010 #1 How can I set up conditional formatting for the following: 3.5 = red Click to expand... 2.5 - 3.49 = yellow 2 - 2.49 = green <2 = blue Thanks, Steve
How can I set up conditional formatting for the following: 3.5 = red Click to expand... 2.5 - 3.49 = yellow 2 - 2.49 = green <2 = blue Thanks, Steve
B Bob Phillips Mar 11, 2010 #2 Set all the cells to one of the colours that apply the 3 conditions to them via CF, effectively 4 colours.
Set all the cells to one of the colours that apply the 3 conditions to them via CF, effectively 4 colours.
S Steve Mar 11, 2010 #3 Perfect. Thanks Bob Phillips said: Set all the cells to one of the colours that apply the 3 conditions to them via CF, effectively 4 colours. -- HTH Bob . Click to expand...
Perfect. Thanks Bob Phillips said: Set all the cells to one of the colours that apply the 3 conditions to them via CF, effectively 4 colours. -- HTH Bob . Click to expand...
