Thread: Conditional Format: % of total
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
AussieBec AussieBec is offline
external usenet poster
  
Posts: 14
Default Conditional Format: % of total
Hi Not sure if this can be done, I just can't work it out at this point.

Scenario:
A1: $10000
B1: $ 7500 (this is has a sum total)

How to I colour B1 when it reaches 25% of A1?
TIA
Bec
Reply With QuoteReply With Quote