Macro: Setting a cell value from another cell
Closed
Cashel
-
Sep 19, 2009 at 08:36 AM
venkat1926 Posts 1864 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Sep 19, 2009 at 08:46 PM
venkat1926 Posts 1864 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Sep 19, 2009 at 08:46 PM
Related:
- Macro: Setting a cell value from another cell
- If cell contains (multiple text criteria) then return (corresponding text criteria) ✓ - Excel Forum
- Run macro when cell value changes - Guide
- Excel conditional formatting if another cell contains specific text ✓ - Excel Forum
- Highlight cell if another cell contains text ✓ - Excel Forum
- Automatically Run Macro from a calculated cell value change ✓ - Excel Forum
1 reply
venkat1926
Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
810
Sep 19, 2009 at 08:46 PM
Sep 19, 2009 at 08:46 PM
you want to color if any cell value is 87
use find function either as a formulla in speradsheet or in macro
example code statements
use find function either as a formulla in speradsheet or in macro
example code statements
dim cfind as range set cfind=activesheet.usedrange.cells.find(what=87,lookat:=xlwhole) cfind.interior.colorindex =41