View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
RJH RJH is offline
external usenet poster
 
Posts: 44
Default Detecting conditional formatting

I'm tring to detect when a cell turns red.
Let's say Sheet 2 Cell B2 contains a number.
When that number is below 3 the cell is turned red with conditional
formatting.
I need to detect the color change.
I can catch the number dropping below 3 but that doesn't work for me, I need
to dectect the color change. (Excel 03)

How could I do this?

Thanks!

RJH