View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
JLGWhiz[_2_] JLGWhiz[_2_] is offline
external usenet poster
 
Posts: 1,565
Default Button Color based on cell

You would be better off using the data content of the cell as criteria
rather than the fill color of the cell, especially if the cell is filled by
conditional format.


"Thanks" wrote in message
...
Hello
How can I change the button color based on cell contents or fill color. I
have button one sheet and I would like for it to mimic the color of a cell
in
another sheet. The cell content is either "Red", "Yellow", "Green".