How to give conditional formatting to particular cell of a row and not an entire column
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.
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?