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

Select column A and enter =B1=1 in CF formula field! Choose yellow pattern!

Regards,
Stefi

€žGD€ ezt Ã*rta:

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