View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Ben Ben is offline
external usenet poster
 
Posts: 10
Default 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.