MrExcel Publishing
Your One Stop for Excel Tips & Solutions

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


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

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

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.

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