How to color cells, if the cells are a part of the formula.

[srinidhi]

I have formula at the beginning of a cell & want to color only those cells that are a part of the formula

EX:A1 =sum(A2+A3+A5+415+A20)

I just want to change the cell color for A2, A3, A5, 415, A20


Can this be done without VBA also.

 

[Luke M]

Do you need this to be dynamic, or is this a "1-off" thing? dynamically, you're going to need to use VB as there is no native function in XL that can detect formula contents. If you just need a quick highlight:

1. Select A1

2. Hit Ctrl+[

3. All direct precedent cells are now selected (note that 415 is not a cell)

4. Format cell color as desired.

 

[srinidhi]

Thanks a ton, this is what I was looking for.

 

[Hui]

Also Sum should be

=sum(A2,A3,A5,A15,A20)


or just

=A2+A3+A5+A15+A20