Macro to apply several conditional formatting criteria

[useR]

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.

 

[useR]

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
bold white.

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