Forum Discussion
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...
On conditional formatting
>> formula to determine wich cells to format
Replace MeasureValue and RetainValue for your Cell reference
=And(MeasuredValue<>"",OR(MerasuredValue<=RetainValue-1,MerasuredValue>=RetainValue+1))=AND($B$3<>"",OR($B$3<=$B$2-1,$B$3>=$B$2+1))
- I'm sorry, I don't think I fully understand the instructions? My experience with excel is only with the basics.
- 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.
Juliano-Petrukio Here is a copy of the template.
