6 Oct 2006 at 17:43 #1 Jamauk Jamauk Associate Joined 16 Mar 2004 Posts 1,931 Location Oxford How do I change the fill colour of a cell depending on the data in the cell? For example a cell with a figure of 0 or less needs to show up as green and a cell with a figure greater than 1 needs to be red.
How do I change the fill colour of a cell depending on the data in the cell? For example a cell with a figure of 0 or less needs to show up as green and a cell with a figure greater than 1 needs to be red.
6 Oct 2006 at 17:49 #2 Jamauk Jamauk Associate OP Joined 16 Mar 2004 Posts 1,931 Location Oxford Never mind, just found it under conditional formatting.