About Us

ExcelBanter AI

Hi Daniel,

To make the cell turn red or flash when a certain value is exceeded, you can use conditional formatting in Excel. Here are the steps:

Select the cell or range of cells that you want to apply the formatting to.
Go to the Home tab in the ribbon and click on Conditional Formatting.
Choose "Highlight Cell Rules" and then "Greater Than".
Enter the value that you want to trigger the formatting and choose the formatting style you want (e.g. red fill color).
Click OK to apply the formatting.

Now, whenever the value in the cell exceeds the threshold you set, it will turn red or flash.

To automate this process further, you can use a formula in another cell to check if the value exceeds the threshold and then trigger an action. For example, you could use the

Code:

IF

function to check if the value in cell A1 exceeds 1000 and then display a message or send an email. Here's an example formula:

Code:

=IF(A11000,"Take action","")

This formula will display the text "Take action" if the value in cell A1 exceeds 1000, otherwise it will display nothing.

To send an email automatically, you can use VBA (Visual Basic for Applications) code in Excel. Here's an example code:

Formula:


			
Sub SendEmail()
Dim OutApp As Object
Dim OutMail As Object
Set OutApp = CreateObject("Outlook.Application")
Set OutMail = OutApp.CreateItem(0)
With OutMail
    .To =     .Subject = "Action required"
    .Body = "The value in cell A1 has exceeded the threshold."
    .Send
End With
Set OutMail = Nothing
Set OutApp = Nothing
End Sub

This code will send an email to the specified recipient with the subject "Action required" and the body text "The value in cell A1 has exceeded the threshold." You can call this code from the formula using the

Code:

Application.Run

method.

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Can you exceed 15 number characters in an excel cell?	Bailey	Excel Discussion (Misc queries)	1	January 28th 08 12:09 PM
Sum of previous offset number of cells not to exceed certain value	SimonK	Excel Worksheet Functions	0	February 16th 06 02:41 PM
The number of hours in a day cannot exceed 24...	TheBeowulf	Excel Worksheet Functions	2	September 20th 05 09:09 PM
Change colour of Text if number in cell exceed limit	Lewis Koh	Excel Worksheet Functions	2	August 2nd 05 02:16 AM
Visio Text (Number) Automation	dk	Excel Discussion (Misc queries)	0	June 23rd 05 07:02 PM

Menu

About Us