How to give conditional formatting to particular cell of a row and not an entire column

Options
Akshata Kulkarni
Akshata Kulkarni ✭✭
edited 02/07/22 in Smartsheet Basics

I am creating a dashboard for my organization which will take an average values from multiple columns. The dashboard gives us an summary of all the data. Let say, in the Column 1, Total sales has value 1%, Revenue Generated has value 45% and Franchises success has 99% value. I want to apply conditional formatting to each row/cell differently.

example:

If total sales is below 5%, give the cell Red color

If Revenue Generated is above 40%, give the cell Red Color

Or, If Franchises Success is above 40% give the cell Green Color

All the cells will have different conditions, the cell value can be in $, %, text or decimal.

How should I apply conditional formatting to each cell in a row and not entire column?


image.png


Answers