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) |