Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.
Formula to highlight a cell
Options
Denise
✭
What would the formula be if I want a cell to be highlighted in a particular color depending on the entry in another column. Example: If column A has the word "Light" in it then column D is highlighted yellow.
Thanks!
Comments
-
Denise,
What you are probably looking for is Conditional Formatting
https://help.smartsheet.com/articles/516359-conditional-formatting
It won't do a calculation, but handles most of the conditonal formatting needs directly (for me)
Hope this helps.
Craig
This discussion has been closed.