| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
can I set-up an alert in a cell?
Say I want the text to change to red in cell A1 if the number is 100 or <
50. Can that be done in Excel? |
|
#2
|
|||
|
|||
|
Hi Scott
this can be done using Conditional Formatting select A1 choose format / conditional formatting choose formula is type =OR($A$1100,$A$1<50) choose format in the middle of the screen select the color drop down and choose RED click OK twice -- Cheers JulieD check out www.hcts.net.au/tipsandtricks.htm ....well i'm working on it anyway "Scott" wrote in message ... Say I want the text to change to red in cell A1 if the number is 100 or < 50. Can that be done in Excel? |
|
#3
|
|||
|
|||
|
Out-freaking-standing!!! Thanks very much!!
Scott "JulieD" wrote: Hi Scott this can be done using Conditional Formatting select A1 choose format / conditional formatting choose formula is type =OR($A$1100,$A$1<50) choose format in the middle of the screen select the color drop down and choose RED click OK twice -- Cheers JulieD check out www.hcts.net.au/tipsandtricks.htm ....well i'm working on it anyway "Scott" wrote in message ... Say I want the text to change to red in cell A1 if the number is 100 or < 50. Can that be done in Excel? |
|
#4
|
|||
|
|||
|
Look at Debra Dalgleish's pages on conditional formatting:
http://www.contextures.com/xlCondFormat01.html -- Regards, Tom Ogilvy "Scott" wrote in message ... Say I want the text to change to red in cell A1 if the number is 100 or < 50. Can that be done in Excel? |
|
#5
|
|||
|
|||
|
you're welcome :)
-- Cheers JulieD check out www.hcts.net.au/tipsandtricks.htm ....well i'm working on it anyway "Scott" wrote in message ... Out-freaking-standing!!! Thanks very much!! Scott "JulieD" wrote: Hi Scott this can be done using Conditional Formatting select A1 choose format / conditional formatting choose formula is type =OR($A$1100,$A$1<50) choose format in the middle of the screen select the color drop down and choose RED click OK twice -- Cheers JulieD check out www.hcts.net.au/tipsandtricks.htm ....well i'm working on it anyway "Scott" wrote in message ... Say I want the text to change to red in cell A1 if the number is 100 or < 50. Can that be done in Excel? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how to create a variable column in cell reference | Excel Worksheet Functions | |||
| How can I get a cell locked if the condition is false? | Excel Worksheet Functions | |||
| Can a Formula in Cell X modify Cell Y? | Excel Discussion (Misc queries) | |||
| inserting data from a row to a cell, when the row number is specified by a formula in a cell | New Users to Excel | |||
| VLookup resulting in a blank cell... | Excel Worksheet Functions | |||
Linear Mode
