VBA Macro and Text Boxes

[Snap]

Hi

I am very new to VBA and macros but I understand the concept and I am using Excel 2007.

I am trying to do some conditional formatting for work but I am struggling as you cannot do that for text boxes.

I have a spreadsheet where I will input data. This is then translated to percentages which is then put into a one page report using text boxes.

What I want to be able to do is make a macro for a range of percentages which will in turn fill the background of the text box with a colour. depending on the percentage in a given cell. For instance:

100% - Green
80% to 99% - Amber
79% or less - Red

I have the developer tabs open and Active X with allowed access.

Any help would be much appreciated.

Kind Regards
Chris

[MarvinP]

Hi Chris,

Why not do the calculations in normal Excel Cells and do Conditional Formatting on them. Then do a Print a selected range instead of trying to print your text boxes?