View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
GD GD is offline
external usenet poster
 
Posts: 83
Default Conditional formatting, based on a different cell?

Is it possible to use conditional formatting on one cell, based on the value
or conditions in another cell? In other words, if I wanted the cells in
column A to have a yellow fill color for every row that has a value of 1 in
column B, what kind of formula would I use in conditional formatting to
accomplish this?

Any help? Thanks!
--
GD