vijay.vizzu
Member
Dear All,
I want to try a task in excel, but can't able to acheive, so please help me to resolve it
By conditional formatting, i am highlighting the entire row with Yellow color, now i want to put a vba code which can put 1 in a cell (any cell in a column) in that highlighted row. I am trying to put a code like activecell.interior.color = vbyellow, but it can't detect the color cells. Becoz the cells are highlighted by CF.
So is there any way to detect these cells
Please suggest
Regards
Vijay
I want to try a task in excel, but can't able to acheive, so please help me to resolve it
By conditional formatting, i am highlighting the entire row with Yellow color, now i want to put a vba code which can put 1 in a cell (any cell in a column) in that highlighted row. I am trying to put a code like activecell.interior.color = vbyellow, but it can't detect the color cells. Becoz the cells are highlighted by CF.
So is there any way to detect these cells
Please suggest
Regards
Vijay