Pete
01-27-2010, 02:00 PM
Hi
Need a macro that will do the following steps for the following range of data:- Using column A
1. conditonal format any Zero (0) values in column J from J2 onwards until last cell - based on column A
2. range J2:AA last cell (based on column A) show all negative numbers i.e. -143.90 as (143.90) in red.
Need a macro that will do the following steps for the following range of data:- Using column A
1. conditonal format any Zero (0) values in column J from J2 onwards until last cell - based on column A
2. range J2:AA last cell (based on column A) show all negative numbers i.e. -143.90 as (143.90) in red.