How to color cells which contain formula?

[Dhanola]

How to color cells which contain formula?​

also posted here
Hey, there I have an excel sheet in which there is a column that has all cells with either of the two formulas one is the sum, and the other is sumif(). My question is how to color those cells only which contain the sum() function as the outer function?




as you can see in the above excel sheet I have selected column R and in this, I want to color only the cells which are between the cells written "amount" and the green colored cell in which sumifs() are used and the rest white cells with sum as outer function.





so like in the above image I want to color the cells like above for each week and for each month?
please check it on the excel sheet I am sharing here:

https://easyupload.io/vyvzeu

 

[etaf]

maybe
=LEFT(FORMULATEXT(R1),7)

then in conditional formatting

=LEFT(FORMULATEXT(A2),7)="=sumifs"

but your example does
in row 8 - has a different formula = SUM(SUMIFS
anyway

really a small sample sheet is all thats needed trying to use xl2bb - just crashes

it will only be on dropbox for a day or 2

PERSONAL EXPENSE CALCULATOR - etaf.xlsx

Shared with Dropbox

www.dropbox.com

as its full of macros and conditional formatting
but mine is in yellow

 

[Dhanola]

hey, thanks for helping but I want one last help: if you can add one more condition in it i.e. if a cell has the function sumifs and also the value in the cell is greater than 0 then color it. I mean both conditions must be met then only it color else not.

 

[etaf]

ok,
try
=AND(R1>0,LEFT(FORMULATEXT(R1),7)="=sumifs")

i dont understand the sumifs

 

[Dhanola]

ok,
try
=AND(R1>0,LEFT(FORMULATEXT(R1),7)="=sumifs")

i dont understand the sumifs

no not working even if I use sum in place of "sumifs" for a cell having "sum" in it

 

[etaf]

working for me - see dropbox

 

[Dhanola]

working for me - see dropbox

wow! thanks, it is working perfect and for greater than 0 also. Thanks again!!

 

[etaf]

You are welcome