Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
conditional formatting help please
I've made a conditional format so when a cell is equal to 0 it turns
red/bold. How can I make the cell next to it turn/bold as well when the above happens? eg. cell A2 has the above conditional format, I want A1 turn red/bold too when A2 turns red/bold. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
conditional formatting help please
hi,
conditional formate for A1... If formual is - =if(A2=0,1,0) set format to red bold the above formula sets up a true/false condition and the conditional format in cell A1 will react to the contents of cell A2. regards FSt1 "Ben" wrote: I've made a conditional format so when a cell is equal to 0 it turns red/bold. How can I make the cell next to it turn/bold as well when the above happens? eg. cell A2 has the above conditional format, I want A1 turn red/bold too when A2 turns red/bold. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
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 | |||
Conditional Formatting | Excel Discussion (Misc queries) |