Forum Discussion

Copper Contributor

Sep 01, 2021

Change colors based on values of other cells

Hello, I need some help with excel. Below are images of the worksheet template I use. For every project, I start with a blank template and then input different values based on my testing, as can...

excel

Formulas and Functions

Office Scripts

Oscar_Santos

Copper Contributor

Sep 02, 2021

I'm sorry, I don't think I fully understand the instructions? My experience with excel is only with the basics.

Juliano-Petrukio

Bronze Contributor

Sep 02, 2021

Can you please share a sample File such like your screenshots? As you mentioned, you are having some difficulties in understand my step-by-step.

Oscar_Santos
Copper Contributor
Sep 02, 2021
Juliano-Petrukio Here is a copy of the template.
Template Sample.xlsx13 KB
- Juliano-Petrukio
  Bronze Contributor
  Sep 02, 2021
  Oscar_Santos
  Find attached
  2021-09-02-Template Sample-Solved.xlsx28 KB
  - Oscar_Santos
    Copper Contributor
    Sep 02, 2021
    Thank you! This is very close to what I want! Can you explain how I can change the range? Like, lets say I want it to be a difference of 2.0 instead, as in, if the RETAIN value for pH is 4.0, it changes if it's 2.0 or 6.0? How do you I change that in the formula?