Hello, i can create a table of results from a general formula. now what i
want to do is color the cells according to the logic "if the cell value is
between (eg) 20 & 40 then colorA , if cell value is greater than 40 then
colorB"
Suggestions please!!

Jim, have a look at conditional formatting, under format

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"jim mcgrath" wrote in message
...
Hello, i can create a table of results from a general formula. now what i
want to do is color the cells according to the logic "if the cell value is
between (eg) 20 & 40 then colorA , if cell value is greater than 40 then
colorB"
Suggestions please!!

Hi Jim

Highlight the cells,
FormatConditional FormattingCell value isBetween20and40 Choose
Format Add Cell value isdropdown to select Greater than40 Format as
required.

Regards

Roger Govier


jim mcgrath wrote:
Hello, i can create a table of results from a general formula. now what i
want to do is color the cells according to the logic "if the cell value is
between (eg) 20 & 40 then colorA , if cell value is greater than 40 then
colorB"
Suggestions please!!

Try conditional formatting

format menu conditional format

"jim mcgrath" wrote:

Hello, i can create a table of results from a general formula. now what i
want to do is color the cells according to the logic "if the cell value is
between (eg) 20 & 40 then colorA , if cell value is greater than 40 then
colorB"
Suggestions please!!

Thanks for your suggestions; easy when you know how..!

"jim mcgrath" wrote:

Hello, i can create a table of results from a general formula. now what i
want to do is color the cells according to the logic "if the cell value is
between (eg) 20 & 40 then colorA , if cell value is greater than 40 then
colorB"
Suggestions please!!