Need help creating a macro to apply this set of 5 conditional format criteria
to a data range in my report? Font is Arial regular, 11 point.

IF current cell value is not equal to ="N/A", THEN current cell font is black.
IF current cell value is </= 4.004, THEN fill current cell color bright
green, font is black.
IF current cell value is between 4.005 AND 4.099, THEN fill current cell
color yellow, font is black.
IF value in cell one column Left same row is /= 4.005, AND current cell
value is /= 4.005, THEN fill current cell color red, font is bold white.
IF current cell value is /= 5.0, THEN fill current cell color red, font is
bold white.

Using MS Office Excel 2003, MS Windows XP Pro 2002.

Thanks!