Excel version: Microsoft excel for microsoft 365 MSO (version 2406 build 16.0.17726.20078) 64-bit
Hello internet friends, I am trying to create an interactive spreadsheet with conditional formatting that will update color values on the fly but I am having an issue with the conditional formatting being hard coded to an absolute reference. If I switch it to a relative reference, the cells do not follow the rules.
Example: I have Numerical Data in columns F and G that looks something like this
| Tolerance | 0.1 |
|---|---|
| DZ | DZ with adjustment |
| -0.07 | +0.03 |
| +0.5 (colored) | +0.055 |
| -0.03 | +0.01 |
| -0.6(colored) | +0.2 (colored) |
So I have the conditional formatting set to the DZ and DZ with adj