| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
when using a formula can I have certain values in red
I want to set an alert in my speadsheets if the number excededs a set value.
I have set the formular for true or false but would like it in red so I can't miss it. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
when using a formula can I have certain values in red
Use Data Validation with a formula that will evaluate to TRUE. Note the
formula should evaluate to TRUE *NOT* return TRUE eg. =A1025 -- HTH Sandy In Perth, the ancient capital of Scotland and the crowning place of kings Replace @mailinator.com with @tiscali.co.uk "JD@Morrison" wrote in message ... I want to set an alert in my speadsheets if the number excededs a set value. I have set the formular for true or false but would like it in red so I can't miss it. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
when using a formula can I have certain values in red
formatconditional formatting
-- Don Guillett Microsoft MVP Excel SalesAid Software "JD@Morrison" wrote in message ... I want to set an alert in my speadsheets if the number excededs a set value. I have set the formular for true or false but would like it in red so I can't miss it. |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
when using a formula can I have certain values in red
"Don Guillett" wrote in message
... formatconditional formatting Ah yes! That is just what I was thinking - it was just my fingers that got it wrong <g -- HTH Sandy In Perth, the ancient capital of Scotland and the crowning place of kings Replace @mailinator.com with @tiscali.co.uk |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
when using a formula can I have certain values in red
My fingers do that also
-- Don Guillett Microsoft MVP Excel SalesAid Software "Sandy Mann" wrote in message ... "Don Guillett" wrote in message ... formatconditional formatting Ah yes! That is just what I was thinking - it was just my fingers that got it wrong <g -- HTH Sandy In Perth, the ancient capital of Scotland and the crowning place of kings Replace @mailinator.com with @tiscali.co.uk |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formula to get values between 8 and 15 | Excel Worksheet Functions | |||
| Build excel formula using field values as text in the formula | Excel Worksheet Functions | |||
| copy values generated by conditional formula in one sheet to the other work sheet as values | Excel Worksheet Functions | |||
| copy values generated by conditional formula in one sheet to the other work sheet as values | Excel Discussion (Misc queries) | |||
| Using formula values | Excel Discussion (Misc queries) | |||
Linear Mode
