Thread: how do i make a cell turn red if value is less than 0?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
John Moore John Moore is offline
external usenet poster
  
Posts: 70
Default how do i make a cell turn red if value is less than 0?
Use conditional format ,,,, where cell value equals "0" ,,, format to RED

"Megglesface" wrote:

i have a list of numbers on my worksheets, inclusing some zeros. i would a
formula that means whenenver a cell just has 0 in it it will show as red.

Is this possible?

Thanks
Reply With QuoteReply With Quote