Macro to apply several conditional formatting criteria

Can you help me create 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.

Thanks!
IF current cell value is >/= 5.0, THEN fill current cell color red, font is
bold white.

> Can you help me create 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!