Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
conditional formatting
Is it possible to format one cell dependent on the value
of a different cell? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
conditional formatting
One way:
Select B1. Choose Format/Conditional Formatting... CF1: Formula is =A110 Format1: Pattern/Red will cause B1 to have a red background when A1 is 10. In article , "esslinger" wrote: Is it possible to format one cell dependent on the value of a different cell? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can I convert conditional formatting into explicit formatting? | Excel Discussion (Misc queries) | |||
Conditional formatting--different formatting depending on cell con | Excel Discussion (Misc queries) | |||
Protect Cell Formatting including Conditional Formatting | Excel Discussion (Misc queries) | |||
conditional Formatting based on cell formatting | Excel Worksheet Functions | |||
Conditional Formatting that will display conditional data | Excel Worksheet Functions |