It sounds as if you want conditional formatting. With CF and cells on
another sheet, you should name the cells (InsertNamedefine...), and then
use that name in the CF.

--
---
HTH

Bob

(change the xxxx to gmail if mailing direct)


"Chris" wrote in message
...
I would like to use the IF function to highlight data on a seperate sheet,
when data is below a certain percentage, does anyone know how to do this?