Formula to highlight a cell

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!

J. Craig Williams

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