conditions using colors

lgarcia · Apr 1, 2004

anyone knows if there`s a way using conditions, to fill the cell with
colors?, i mean not filling all the cells manually?

***** Posted via: http://www.ozgrid.com
Excel Templates, Training & Add-ins.
Free Excel Forum http://www.ozgrid.com/forum *****

Norman Harker · Apr 1, 2004

Hi lgarcia!

Use Format > Conditional Formatting

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.

David McRitchie · Apr 1, 2004

Hi lgarcia,
I have a page on Conditional Formatting
http://www.mvps.org/dmcritchie/excel/condfmt.htm

If you need more than 3 interior colors (+default) then you
would need a macro. An Event macro is what you would
normally use if you can't use C.F. (not as nice as C.F.)
http://www.mvps.org/dmcritchie/excel/event.htm#case

conditions using colors

lgarcia

Norman Harker

David McRitchie