Conditional Formatting Cells used to Sum

[debraj_patra1]

Hi I am Debraj, i want to know is there any way to set up conditional format to the cells used in a formula which is in another cell.

Kindly help me out on this.

 

[kevatarvind]

yes its possible you can use formula in conditional format using another cell

if you want help to do that i will be happy to help you contact any time

 

[debraj_patra1]

i would be grateful if be helped on this,

but i need is if a formula is cell a1= a2+a4+a5, is there any conditional formatting technique that i can format the cell a2, a4, a5 referring to a1.

 

[kevatarvind]

yes you can

in which cell you want to use conditional formating and what is the condition ?

 

[debraj_patra1]

Condition is the cells used in the sum in cell A1 to be colored as red.

 

[jamtay317]

=$A$1 should do it if you want it to turn red if its the same as A1

 

[debraj_patra1]

for example cell b1 is the sum of cell a1,a2,a4. i want to set up conditional formatting in column A base of which would be the cells used to get the sum which is in Cell B1.

 

[jamtay317]

so what you want is ti high light the cells that add up to = b1?

 

[debraj_patra1]

Yes, exactly....