problem not clear. however use format-conditional formatting


Nonsequitr wrote in message
...
Does anyone know if you can write a macro in Excel that will result in
certain cells being colored in if a specific condition exists? I know you
can
write for the condition, but can the product actually go out and color a
specific cell say red if the correct condition exists?
Thanks,