simple one: If cell highlighted, then copy value

**hmm321** · 10-26-2015, 01:33 AM

One more question please. looked everywhere and can't figure it out. I'm sure it's simple for most of you...

if any cell is highlighted, then make the value zero

see attached for sample.

again, appreciate it. nearly done with this over my head project!

**bebo021999** · 10-26-2015, 02:10 AM

With formula, excel could not define what kind of format the cell was. If the cell is formatted with condition, use that condition, if not, VBA can help.

**hmm321** · 10-26-2015, 02:18 AM

I'm afraid i have no idea about vba. Guess this isn't so simple, ha. Any input greatly appreciated.

**bsuperiorsystem** · 10-26-2015, 02:19 AM

use this function:

Please Login or Register  to view this content.

then apply this function in your workbook. look at yellow cells
Feel free to find more tutorials on my Excel Blog.

**bebo021999** · 10-26-2015, 02:24 AM

Is it able to use a helper column? If you want to highlight B1, instead of highlight it, type 1 in to A1, then apply condition formating on cell B1 to highlight. A1=1 will be condition of C1: IF(A1=1,0,B1)