Hi, Sorry if I am being a bit naive here, but why do you need VBA to format the column A0? could you not simply use a conditional formula on Column A0 that points to the rows in question?
Garry
Quote:
Originally Posted by deepika :excel help[_2_]
i want to write in VBA teh conditional formatting with the following pseudo
code inside a macro :
if slippage= 0 then color= green
else if slippage <0 then color = blue
else if slippage 0 color = red
when any value<0 in AO column for any row then that cell should be in color
green... similarly for <0 and =0 also
here the slippage column is the column name AO. the rows in this sheet keeps
adding up. so i cannot give specific range... the slippage is in column AO
and today theer are 50 rows and topmor 2 rows can be added etc. so it should
be general;. please help. rows are dynamic
|