Select your cells
format|conditional formatting
cell value is: less than: 100

Give it a nice format.

jackyg wrote:

I have a similar question. In my spreadsheet I want it to highlight
everything under 100 and the cells already contain formulas. How do you
do that?

Thanks!

--
jackyg
------------------------------------------------------------------------
jackyg's Profile: http://www.excelforum.com/member.php...o&userid=26898
View this thread: http://www.excelforum.com/showthread...hreadid=401167

--

Dave Peterson