Changing bg color when a certain number is entered

[dougmcc1]

I want to change the background color of cells automatically when
certain number is entered. If the number is less than or equal to 500
I want the bg color to change from white to green, if it's over 5k an
under 100k then I want it to change from white to yellow and if it'
equal to or greater than 100k I want it to change from white to red.

Does anyone know how to do this? I'm not too good with macros.

Thanks

 

[mudraker]

Are you sure you want to use a macro to do this..

It sounds like Conditional Formatting may suit your need

 

[Vasant Nanavati]

Look at Format | Conditional Formatting.

 

[dougmcc1]

I thought a macro was my only option. I dont even know what "Conditiona
Formatting" means

 

[Carl Brehm]

Use conditional formatting. No macro needed.

--
Carl & Linda Brehm
Lake Lafourche Bird House
Hebert, LA
Keets, Tiels, GN Lories, Quakers
Mitred Conures, TAG's, Bourkes
Cages

 

[dougmcc1]

I applied Conditional Formatting to get the desired effects, but I don
want to have to enter the conditions every time. I want the bg color t
change as soon as I enter the number. I want something that run
"behind the scenes" as I edit my Excel document. Is this possible?

Thanks for the suggestion though. Neat feature

 

[jomni]

Conditional Formatting is still the easiest option. Just copy and past
special (format only) to the whole worksheet

 

[Rob van Gelder]

If you mean: change the colour as I am typing - this is not possible.
Conditional Formatting only works once you've finished editting a cell.

If you mean: I have to apply conditional formatting to each new cell I use -
you can apply conditional formatting to an entire column and/or row.

 

[dougmcc1]

I want to see the effects as I work instead of stopping to copy an
paste ever so often

 

[Frank Kabel]

Hi
in addition to all answers you may have a look at the following sites
for more information about conditional formating:
http://www.contextures.com/xlCondFormat01.html
http://www.cpearson.com/excel/cformatting.htm

 

[dougmcc1]

Oh I guess the cells do change bg color after I enter a number and pres
enter. If I'm still in that column anyway.

I guess this will do. Thanks

 

[Frank Kabel]

Hi
there's no way to change the color while typing. So you first have to
finish the entry. after this conditional format will change your
formats

 

[Tom Ogilvy]

He means to do it one time to the areas that you will ever work in.

then you don't have to stop and copy. You set up the sheet with the formula
pre-entered. then start your work.