Change background color in a cell.

G

gio123bg

Hi,
I wish to test a value in a cell and change the background color is a
range of values is present.
More exactly:

IF x <= 30 then read color
IF x > 30 & x < 60 then yellow
IF x >= 60 then dark

Is it possible? Many thanks in advance for your kind cooperation.
Regards,

gio123bg
 
N

Norman Harker

Hi gio123bg!

Use conditional formatting.

It's pretty intuitive but post back if you have problems.

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to filter rows data based on background color of individual cells 3
How to make font color oppose to cell interior color 4
Changing cell color with a formula? 4
Changing color 9
Change text box background color depending on value in Label Reports 0
change the background color of a cell in access 2010 5
how to format cells -fill color 2
Need to change Autofilters behaviour in Excel 2003 1

Top