View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Garyp1961 Garyp1961 is offline
external usenet poster
 
Posts: 6
Default Conditional formating

Hello All,
I would like to know how to format a cell where it will give me the number 1
when I enter any type of data in a different cell. Example I enter data in
cell a1 and I would like for my formatted cell say it's c4 to show the number
1
Thanks for any help in advance.