Is there a way to trigger conditional formatting from within VB? Maybe
that's not the right question, but here's what I'm trying to do:

Each row is a record containing an email address. On one sheet I have
parts of the record averaged, triggereing conditional cell shading
depending on the results. 1-2=yellow, 2-3=orange etc.

What I want to do is something like

If (average) from sheet 'tally' is from 1-2
then find the row containing that email address on sheet 'records'
apply the coloring to the row continaing that email address, depending
on what the original average was.

If this is too convoluted, feel free to tell me that I'm not explaining
it well enough.