Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Conditional Formatting
I have a rather large worksheet that will have hundreds of cells with
conditional formatting. Most of them are the same (only the cells and value ranges change). Here is an example of a conditional format I need: If the value of B4 is between 96 and 96.04 then B44 is filled yellow. |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Conditional Formatting
If the value of B4 is between 96 and 96.04
Assuming you mean =96 and <=96.04... Select cell B44 Goto the menu FormatConditional Formatting Formula Is: =AND(B4=96,B4<=96.04) Click the Format button Select the Patterns tab Select the desired color OK out -- Biff Microsoft Excel MVP "Scores" wrote in message ... I have a rather large worksheet that will have hundreds of cells with conditional formatting. Most of them are the same (only the cells and value ranges change). Here is an example of a conditional format I need: If the value of B4 is between 96 and 96.04 then B44 is filled yellow. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Protect Cell Formatting including Conditional Formatting | Excel Discussion (Misc queries) | |||
conditional Formatting based on cell formatting | Excel Worksheet Functions | |||
conditional Formatting based on cell formatting | Excel Worksheet Functions | |||
Conditional Formatting | Excel Discussion (Misc queries) | |||
Conditional Formatting that will display conditional data | Excel Worksheet Functions |