Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
highlight only formula
hi, i am having 2 worksheets, In worksheet 1 some cell have formula but it is
calculation depends upon Worksheet 2, so i want to hightlight the changes at Worksheet1 at those cells, where formula is change depend upon the change in Worksheet2. Eg. Worksheet1 Code-Product-Qty x-xyz-50 y-xyz-100 Formula for Qty:Vlookup(Index,match(<cellref,<range,False),3 ) Worksheet2: Code-QTY-PRICE (Where Qty,and price are changeble but code is fixed) x-50-1000 y-100-2000 Now suppose, for the Code= Y, i changed the Qty=50, then it should only hightlight the formula for the Code Y Thanx |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Highlight Five Values With Conditional Formula | Excel Discussion (Misc queries) | |||
Highlight field that are not derived from a formula | Excel Discussion (Misc queries) | |||
IF formula to highlight? | Excel Worksheet Functions | |||
formula to highlight specific numbers | Excel Discussion (Misc queries) | |||
Highlight cells with ctrl-click but only un-highlight one cell | Excel Discussion (Misc queries) |