View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
roxiemayfield roxiemayfield is offline
external usenet poster
 
Posts: 21
Default Conditional Format Not Working

I have an employee weekly schedule and have set up 52 weeks (worksheets). I
have the schedule set up to copy from the previous week.

The conditional format is if the value of a cell is < 0, I want the cell to
format to gray pattern. It does format gray but it puts in .00. I do not want
a 0 or a dash - just for the cell to be gray. Can I do this?