say A1 equal to 5 is the condition then

=$A$1=5

will be the entry

joe wrote:

I did the "formula is" I just don't know what to set as the formula.

Thanks.

"Bob I" wrote:


Select row and set Conditional formatting "Formula is" and then the cell
contents requirements.

joe wrote:


How can I make the color of a row automatically change based on the contents
of one of its cells.