.... than what?

You could use Format/ Conditional Formatting/ Cell Value Is/ between/
=50%*A1/ and/ 70%*A1 if you are trying to compare the active cell with cell
A1.
--
David Biddulph

"juanpablo" wrote in message
...
I need to highlight in red if a specific value is between 30% and 50%
lower.