New answers tagged conditional-formatting
1
vote
Accepted
How to conditional format in Google Sheets based on a external resource
Instead of referencing C2, you need to reference $C2.
There are two Conditional formatting rules. Each contains a unique custom formula - one each for the value greater/less than than your buy price.
...
Top 50 recent answers are included
Related Tags
conditional-formatting × 439google-sheets × 428
formulas × 124
google-sheets-dates × 19
google-apps-script × 18
google-sheets-arrayformula × 16
formatting × 9
google-sheets-query × 8
regex × 7
data-validation × 7
date × 7
google-sheets-cell-format × 7
regexextract × 5
google-apps × 3
google × 3
importrange × 3
vlookup × 3
google-sheets-custom-function × 3
google-forms × 2
if-this-then-that × 2
concatenate × 2
filter × 2
microsoft-excel × 2
google-sheets-data-validation × 2
excel-online × 2