Posted to microsoft.public.excel.worksheet.functions
|
|
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
|