View Single Post
  #4   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

Thanks Pete
But how can I write a condition to change cell color?
Daniel

"Pete_UK" wrote:

Flashing text is not really recommended in a worksheet, but if you
must then Chip Pearson shows how to do it he

http://www.cpearson.com/excel/BlinkingText.aspx

You could use Conditional Formatting to change the colour of a cell if
a certain condition is met (more sedate).

Hope this helps.

Pete

On Jul 11, 6:21 pm, Daniel wrote:
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