Formula, automation turn red if value exceed a number

[Daniel]

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

 

[Pete_UK]

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

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

 

[Daniel]

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

 

[Pete_UK]

Well, let's say you have some numbers in A2:A10, and you want to
change the background colour of any cell if it exceeds 25. Highlight
those cells, with A2 as the active cell and click on Format |
Conditional Formatting. In the first box of the pop-up choose Formula
Is rather than Cell Value Is, and then in the Formula box enter:

=A2>25

Click on the Format button, then on the Patterns tab (for background
colour) and choose a colour, eg red. Click OK twice to exit the CF
dialogue box, and then any cells which exceed 25 should have a red
background.

You can affect the foreground colour and the font etc with conditional
formatting, and you can have up to 3 different settings in each cell
(more with Excel 2007). For example, you might want a different colour
if the cell exceeds 20 (as a warning), and a different colour again if
it is above 12. Play about with it to learn how to use it, and you
will find plenty of posts on the newsgroups relating to conditional
formatting.

Hope this helps.

Pete