View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
DTTODGG DTTODGG is offline
external usenet poster
 
Posts: 74
Default Color Cells by macro NOT conditional format

Hello,

I would like to know if there is a way to color a cell based on it's value,
but not using the conditional format command.

If the date in column B is more than 45 days old, make the background of
font bright pink.

I need lots of specific help because I'm not comfortable with the VB editor
yet.

Thank you!