If you mean the formula for less than and equal to replace < with <= in
the formula

For formating the cells select the cells goto format conditional
formating, select cell value is, select condition, 30 and then click on
the format button to choose whatever format appeals to you!

Dav


--
Dav
------------------------------------------------------------------------
Dav's Profile: http://www.excelforum.com/member.php...o&userid=27107
View this thread: http://www.excelforum.com/showthread...hreadid=507201