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?
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?
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?
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.