Change background color in a cell.

  • Thread starter Thread starter gio123bg
  • Start date Start date
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
 
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.
 
Back
Top