View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Daniel Daniel is offline
external usenet poster
 
Posts: 354
Default Formula, automation turn red if value exceed a number


How to write a worksheet function,formula, vlookup so that if a value in a
cell is exceeded, the excel
window will flash or turn to red?

In a financial excel spread sheet, a manager has to keep track on the total
money
every day. If the money is exceed a certain value he has to take actions.

How to make this automation by flashing or turn red or even better send
email?

Thanks
Daniel