David thanks for your help but I dont understand what you mean by setting the
yellow pattern in the format options.

"David Biddulph" wrote:

If you want B1 to turn yellow if E1 is between 95 and 100, then in B1 use
Format/ Conditional Formatting/ Formula Is
=AND(E195,E1<100) then set your yellow pattern in the format options.
--
David Biddulph

"james" wrote in message
...
Hi Pete
E1 contains a value that will return green for a1 or yellow for b1 or red
for c1 depending on the e1 value. I would have b1 to be yellow and all the
others blank if the value in e1 is between 95 and 100.


"Pete_UK" wrote:

Do you mean that E1 contains a value that you want to colour-code
according to the values in A1 to C1 ? Or do you want the values in
A1:C1 to be colour coded? What do you want to happen if you have a
value between 95 and 100 ?

Pete

On Jan 7, 10:48 am, james wrote:
I have three cells a1, b1 and c1 that should indicate green, yellow and
red
respectively when values and range of values are given in say cell e1.
The
values corresponding to the cells a1, b1 and c1 could be 100, 90
<=X<=95 and
<90 respectively. What formula should I use for each cell.
Thanks in advance

James