View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
RBober2 RBober2 is offline
external usenet poster
 
Posts: 3
Default How can I automatically color a cell based upon a condition being

I am trying to make a spreadsheet that when a numbered cell in one column is
used in a second column, that the cell in the first column becomes filled
with color.

Example: I have cells in Column "A" numbered from 1 to 10. In column "C" I
have cells that can be filled with numbers. When I, for example, put the
number 3 in cell C1, then cell A3 would become colorized. When I, for
example, put then number 1 in cell C5, then cell A1 would become colorized.
etc., etc..

Can anyone help?