is there a way to use a macro for conditional formatting?

I have to colour a cell if the value met one of 2 conditionals: "TOP" or
"LOW".

in Sheet 1, I have all the values (E6:E256)
...these values in sheet1 are actually formulas pulling from other sheets
in the same book.
in Sheet 2, I have whether those value are TOP (T6:T256) or LOW (U6:U256)

sample:
E6 in sheet1 has a value of 98% and T6 in sheet2 marks it as TOP so, E6 in
sheet1 should be green
E7 in sheet1 has a value of 5% and U7 in sheet2 marks it as LOW so, E7 in
sheet1 should be red

any ideas how to do this would be greatly appreciate it!

cheers,
Mayte