View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
DisMusBeDaPlaz DisMusBeDaPlaz is offline
external usenet poster
 
Posts: 7
Default Changing Cell Color Based on Value

I have an extensive worksheet that has many conditions.

I am using Excel 2003.

I did not see this article as it relates to my issue, but, I am
wondering if you are able to change the cell color based on
a value that is listed as "0" zero, to a value greater than zero.

Currently my "AE6" cell has a numeric "0". The background
color is "White".

As "AE6" becomes the value of "1", or greater, I would like
the cell "AE6" background color to change to yellow.

I looked through the "F1", "Help" lookup and perhaps did not
see what I felt to be in line with my issue.

Is this possible, to have the background cell color change
when it meets a certain condition?