View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Vaquita Vaquita is offline
external usenet poster
 
Posts: 1
Default Conditional format for complete column

Hi I have the following conditional rule in column Z3
=AE3<(TODAY()-30)

I want to apply it for 50 cells more it means from Z3:Z53 using the
information from AE3:AE50.

Is there a way to do it in just 1 step I don't want to creat 50 rules.

I'm using Vista