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!
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
