COLORING IN CELLS
 

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!!

COLORING IN CELLS
 

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!!

COLORING IN CELLS
 

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!!

COLORING IN CELLS
 

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!!

COLORING IN CELLS
 

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!!