[RESOLVED] How to:- Color a cell with macros disbaled

[satti charvak]

HiVBFroums,
I want to color a cell which will have some integer values and those integer values will decide the cell background color of the 50 odd colors available in excel.

The problem here is that macro are to be disabled, hence I just wanted to know if there is any process to color a cell using "=IF()".

Early help is very desirable.

Kind regards
Satti Charvak

[si_the_geek]

You can do this with Conditional Formatting.. just select the cell(s) to be formatted, then go to "Format" -> "Conditional Formatting", and you will see a dialog in which you can enter conditions and formats.

[satti charvak]

Thanks BOSS,
I never used this. But I see a limitation of only 3 conditions here. Can the conditions we want to use, be increased in number.

Kind Regards
Satti Charvak

[si_the_geek]

I wasn't aware that there was a limit of only 3 conditions, but looking at it I guess that is all you can have.

Unfortunately I dont think you can't use a formula, as there doesn't seem to be any for setting formats (it would also colour the cell of the formula, rather than the one of the value).