Ask a new question

color the cell with formula given?

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

Answer
Answer

If you must ask the same question in different forums, you should always mention that explicitly, with a link to the other posts. Otherwise users might work on your problem in vain because it has already been solved elsewhere.

See here

---
Best wishes, HansV
https://www.eileenslounge.com

1 person found this reply helpful

·

Was this reply helpful?

Sorry this didn't help.

Great! Thanks for your feedback.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this reply?

Thanks for your feedback.

 
 

Question Info

Last updated February 8, 2023 Views 39 Applies to: