View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Kassie Kassie is offline
external usenet poster
 
Posts: 37
Default conditional formatting

Click on Format, Conditional Formatting, change Cell Value to Formula is and
insert this, but change the cell reference to the one you want it to react
to.
=$B$10


--
kassie

never stop learning


"EG" wrote in message
...
i am trying to have a row of cells be a certain color if one particular
cell
is 0, for example. is there a way to do that?

thanks!

eric