> 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!