| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional Format
Hello,
Is it possible to generate conditional format for cells greater than other cell in 20%? Thanks JPG |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Conditional Format
use formula is
=A2-$B$220%*$B$2 or =A21.2*$B$2 -- Regards, Peo Sjoblom "juanpablo" wrote in message ... Hello, Is it possible to generate conditional format for cells greater than other cell in 20%? Thanks JPG |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Conditional Format
If I understand you correctly you want a Conditional Format that will
highlight any number that is greater than or equal to 20% larger than a number in a cell Format Conditional Format Cell Value Is | greater than or equal to | =$A$1+($A$1*20%) hope that helps -- If this reply was helpful, please indicate that your question has been answered to help others find anwsers to similar questions. www.silverbirddesigns.com Fighting Texas Aggie Class of 2009 "juanpablo" wrote: Hello, Is it possible to generate conditional format for cells greater than other cell in 20%? Thanks JPG |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Conditional Format
Great Thanks,
And if I want to format yellow if value less than 20%, if difference is higher than 20% then background red. Thanks a lot guys. JP "Texas Aggie" wrote: If I understand you correctly you want a Conditional Format that will highlight any number that is greater than or equal to 20% larger than a number in a cell Format Conditional Format Cell Value Is | greater than or equal to | =$A$1+($A$1*20%) hope that helps -- If this reply was helpful, please indicate that your question has been answered to help others find anwsers to similar questions. www.silverbirddesigns.com Fighting Texas Aggie Class of 2009 "juanpablo" wrote: Hello, Is it possible to generate conditional format for cells greater than other cell in 20%? Thanks JPG |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Conditional Format (not color format) | Excel Discussion (Misc queries) | |||
| How to create a conditional format that changes the number format | Excel Discussion (Misc queries) | |||
| Conditional Format - Format Transfer To Chart | Excel Discussion (Misc queries) | |||
| copy conditional format to regular format | Setting up and Configuration of Excel | |||
| copy conditional format as ACTUAL format | Excel Discussion (Misc queries) | |||
Linear Mode
