View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Barb Reinhardt Barb Reinhardt is offline
external usenet poster
 
Posts: 3,355
Default Condition Formatting in code. How?

This should help

http://www.ozgrid.com/VBA/excel-cond...ting-limit.htm

"Corey" wrote:



I am trying to set up the above CF in code instead.
I also need to set a 4th colour if the above formula=(c8:r30-TODAY())=1 and colour this white

I do not know how to begin this?

Corey...