Archive of Mr Excel Message Board

Back to Forms in Excel VBA archive index
Back to archive home

Custom Format??

Posted by Tony on December 02, 2001 6:29 AM

I am keeping track of the percentage each of my computer products purchases is in relation to the overall budget (eg:$150.00 Hard Drive purchase = X.XX% of $3000.00 December budget). I would like to be alerted if i happen to spend "over 80%" of the budget by having the percentage number bold or [Red] or one of the pallete color. Can this be done with Custom Formatting?

Thanks,
Tony

Re: Custom Format??

Posted by Paul on December 02, 2001 6:58 AM

use conditional formatting, click on the cell you want to format, go to format, conditional formatting, cell valve is greater than or equal to 0.8,format,pick the format you want

Re: Custom Format??

Posted by Tony on December 02, 2001 7:15 AM

:Thanks for the suggestion Paul but, i have already used the 3 Conditional Formating fields. Is there any other way?

-noir

Re: Custom Format??

Posted by Tom D. on December 02, 2001 8:12 PM

Sounds like a flag. I would suggest formatting an empty cell with the red, bold print you want, then put in a formula along these lines:

=if(sum of % > 80,"Expenditures have reached " & sum(percents) & "%","")

The last quotes will keep the cell blank until you hit above the 80% range.

Re: Custom Format??

Posted by Tony on December 03, 2001 5:54 AM

:Tom, thanks for your reply. I tried your formula in a blank cell and am getting a #NAME? message. What am i doing wrong?

Tony

This archive is from the original message board at www.MrExcel.com.
All contents © 1998-2004 MrExcel.com.
Visit our online store to buy searchable CD's with thousands of VBA and Excel answers.
Microsoft Excel is a registered trademark of the Microsoft Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.