Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
conditional formatting for <= +- 1.0%
I need a cell that is calculating the percent delta RT to be conditionaly
formatted if the value is out of range. one range I am looking for is <= +- 1.0%. Thank you |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
conditional formatting for <= +- 1.0%
Select the range of cells to be formatted; I will assume the first is A1
(adjust as needed) In the Conditional Formatting dialog use: Formula Is =ABS(A1)<1%; then give a format as needed best wishes -- Bernard V Liengme Microsoft Excel MVP www.stfx.ca/people/bliengme remove caps from email "R&D" wrote in message ... I need a cell that is calculating the percent delta RT to be conditionaly formatted if the value is out of range. one range I am looking for is <= +- 1.0%. Thank you |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Protect Cell Formatting including Conditional Formatting | Excel Discussion (Misc queries) | |||
Conditional formatting and IF | Excel Worksheet Functions | |||
conditional Formatting based on cell formatting | Excel Worksheet Functions | |||
conditional Formatting based on cell formatting | Excel Worksheet Functions | |||
Conditional Formatting that will display conditional data | Excel Worksheet Functions |