Is it possible to highlight cells from a different sheet used in a formula

Hello,

Is it possible to highlight cells from a different sheet used in a formula .

like I have 10 ,11,12,13,14,15 in cell A1 to A5 in sheet1

on sheet2 on A1 cell I have a formula like this =Sheet1!A2+Sheet1!A3+Sheet1!A5

So I want to highlight cells A2,A3 and A5 on sheet1

I already tried ctrl+[(which selects just A2 on sheet1 instead of showing 3 cells)

I also tried trace precedents on formulas tab which works but it selects cells one by one instead of selecting the 3 cells at the same time

so is there any way to achieve this without using vba

Thank You

Sourav Bhattacharya

I see,thanks for the response

let me try this using vba then....