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.

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.