Values of K11–K13 are variables. On the Conditional formatting, I want to use the output from those cells in the "Greater than" function. Typing =k11 doesn't work. I'm not really sure on how to do it. I hope you guys can help.
Google-sheets – Format Cells if greater than “value of the cell”
conditional formattingformulasgoogle sheets
Related Topic
- Google Sheets – Why Can’t Refer to Another Cell with Value Comparator
- Google-sheets – Google sheets conditional formatting relative to another cell in the same column
- Google-sheets – Compare value in all cells in a column in Google Sheets
- Google-sheets – Google Sheet formula on finding smallest value larger than 0 does not work inside conditional formatting
- Google Sheets – Fix Conditional Formatting Issues
- Google-sheets – How to conditional format a table in Google Sheets based on two other cell values
Best Answer
You just need to type
=k$11instead.