Look up "Conditional Formatting" in the help files.
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Bill" <Bill @discussions.microsoft.com wrote in message
...
Is there a formula that can be made so when you enter a bank numbers in to
a
column it will red flag those certian numbers on the spredsheet column ie
if
i entered 123 in a cell it would be formatted to come up red?