| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional Format based on other cell's value
How do I make the format of A1 conditional on the value of B1
TIA Stella |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Conditional Format based on other cell's value
Stella
Select the cell whos format you want to change, go to format, conditional format and change condition one to "formula is" and put in your condition in the box. Select your format and hit okay. For example if you want cell A1 to be orange if B1 is greater than 5, enter "formula is" and "=b15" Dave "Stella" wrote in message ... How do I make the format of A1 conditional on the value of B1 TIA Stella |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Conditional Cell Shading (based on the shading of other cells) | Excel Worksheet Functions | |||
| Conditional format in merged cells. | Excel Discussion (Misc queries) | |||
| Conditional Format based on contents of cell. | Excel Worksheet Functions | |||
| Calculate percentage based on cells with conditional formatting | New Users to Excel | |||
| How do I set a Conditional Format for ROWs based on the value of . | Excel Discussion (Misc queries) | |||
Linear Mode
