Hi,
I am new to excel VBA, and here is my requirement.
cell A1 B1
A1 has string(text) wtih background color grey or white
in cell B1 i have to get values like this: if A1's background color is grey then 'True' else 'False'
How can i do this, is this possible with any of excel functions without VBA. if i have to do with vba , can you please help me with sample code.
Thanks,
RK
I am new to excel VBA, and here is my requirement.
cell A1 B1
A1 has string(text) wtih background color grey or white
in cell B1 i have to get values like this: if A1's background color is grey then 'True' else 'False'
How can i do this, is this possible with any of excel functions without VBA. if i have to do with vba , can you please help me with sample code.
Thanks,
RK