conditions using colors

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

lgarcia - 01 Apr 2004 04:03 GMT

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

Reply to this Message

Norman Harker - 01 Apr 2004 04:11 GMT

Hi lgarcia!

Use Format > Conditional Formatting

Post back if you have problems.

Signature

Regards
Norman Harker MVP (Excel)
Sydney, Australia
njharker@optusnet.com.au
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.

Reply to this Message

David McRitchie - 01 Apr 2004 19:46 GMT

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
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

Reply to this Message