Dear All,

I need a user defined function to to update one column value based on background colour of another column..
can you plese suggest some code..

for example
Col A
1223
1224
1225

in these 1223 and 1224 are filled with background colour as 'RED'
1225 filled with background colour as 'Green'

now i have a new column where COL C where i need to fill if Col A backrgound colur is RED then automatically i need to update COLC with Values as 'Inactive' or if col A cell's background colur is 'Green' then 'Active'

I have around 500 rows.. so. just wanted to have function so i can drap the formuale to all rows....