View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Damon Damon is offline
external usenet poster
 
Posts: 30
Default Conditional Formating on Several Cells

So, I've added conditional formating to A2 that logically looks like this:
=if C2=0 then fill is red and if C2=1 then fill is green

I need this formating on the next 80 cells in column A and I need the check
to be on C3,4,5,6,... and so on. How do i copy the conditional formating
like that?
--
Cheers,
Damon