View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Tel Tel is offline
external usenet poster
 
Posts: 39
Default Conditional Formatting dependent on whether cell is populated.

I want to conditionally format cell G2 dependent upon whether there is a
value in cell C2 AND G2

Therefore,
if cell C2 has a value in it and cell G2 doesn't then cell G2 color = Amber
if cell C2 has a value in it and cell G2 has a value then cell G2 color =
Green

Any helpful hints or useful suggestions?

Thanks

Tel