conditional formatting

[Stoker]

anyone know about conditional formatting in excel?
i have a risk calculator and can format cells to change
color, i.e if i put severity 3, likleyhood 3 - 3x3 the
cell will calculate 9 and turn red and other cells
depending on calculation will turn green or orange, what
i want to do is turn the numerical value into text, so
3x3 will turn cell to red and the text will read high
risk. any one know the formula in plain english?
i have office 2002 wiv win xp home

 

[tommyboy]

can you anly have 3 conditional formats>

 

[Frank Kabel]

Hi
in the conditional format dialog: Yes. For more you need VBA (using the
worksheet_change event)

 

[Norman Harker]

Hi Tommyboy!

3 conditional formats + the background format

You can also use the ordinary cell formats for negative, positive and
zero.

And then you can use VBA with Worksheet_change sub-routines to create
more conditions.

But I think that it is accepted that too many formats are more
confusing and aesthetically pretty gross.

 

[Stoker]

Thanks i have something to work with now
Regards Stoker

-----Original Message-----
There are lots of ways, but one way would be to create a

table somewhere in your workbook showing composite risk
and description, like:

1 Low risk
3 Moderate risk
5 High risk
9 Unacceptable risk

in say G1:H4 or whatever, then instead of having your

conditionally formatted cell saying =A1*B1 or something
like that, have:

=VLOOKUP(A1*B1,G1:H4,2,FALSE)

Then you need to change your conditional formatting to

respond to a formula referring to the outcome of A1*B1
rather than the cell value.