Coloring Cells Programatically

**minopharma** · 06-04-2009, 02:31 PM

Hi to all,

In general I have 2 questions:

1. I have the following function written VBA in excel:

Please Login or Register  to view this content.

that give TRUE/FALSE answer. Additionaly I want also the cell where is the answer to be colored, depending on the type of the answer (green for TRUE, red for FALSE). How is this possible?

2. Is it possible to make a toolbar from function (e.g., this function)?

Thanks in advance,
Nikola

**JBeaucaire** · 06-04-2009, 02:37 PM

Use conditional formatting on those cells.

Click FORMAT > CONDITIONAL FORMATTING
Condition1: Cell Value Is: Equal to: False
Format...pattern...red

Add...
Condition2: Cell Value Is: Equal to: True
Format...pattern...green

**kraljb** · 06-04-2009, 02:42 PM

Conditional Formatting is what you are looking to do I think.

You can find it as follows:
Pre-2007:
Format: Conditional Formatting
2007
It's on the HOME in STYLES

Just select the cells that going to be your answers (TRUE or FALSE) and then go to Conditional formatting and select =FALSE and make it Red highlighting and then =TRUE and green highlighting.

Let me know if that works for you...

Thanks,
John

**minopharma** · 06-04-2009, 02:54 PM

Thank you very much for your answers and solutions! I'm using Excel 2003 and I have to say that already tried this way.

My question was is it possible to put this conditional formating into the code above?

Regards,
Nikola