View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Martin Ledgard[_2_] Martin Ledgard[_2_] is offline
external usenet poster
 
Posts: 3
Default Conditional Formatting dependent on another cell

I want to be able to "grey out" names in a list dependent on the numeric
content of an adjacent cell. Is there a way of using conditional formatting
to do this? I have tried using - "Cell Value Is =A1=1" and it doesn't work.
Thanks.