change cell color depending on "text" entered in different cell

Hello all,

I am new to Sheets, but have experience with Excel in my previous life, however I've been retired for a while and seem to have forgotten a lot, plus it seems that sheets syntax / tools are a little different. Any way I am trying to building an action register for my new business.

I want to make the background color of cell A1 change depending on the "text" entered into cell D1.

ie ----> if D1= yes' then A1 background color = Green. Ect.

Easy right..

thank you in advance

Jenifer

That worked ! hanks

Can I have mutual conditions like if D1 = "Yes" or "yes" or "Y" or "y" ? Or do i need to make a format for each one?

thank you!

You have been so nice in helping me and I sure don't want to abuse your kindness, but one more thing... In Excel if I use a rule or formula in cell B1 that is controlled by D1, then highlight the cell and drag the corner tag down the column, the formula will propagate to each cell and the address of each cell will be automatically updated in the formula (unless "$" is used in the address) in each new cell that it gets propagated to. Then each new cell, say B3 will be controlled by the corresponding D3 cell. In Sheets it only makes the formula a range and the first cell then controls all the rest. Is there a way to propagate the formula using the drag down method in Sheets?

Good Morning. Ok... so now when I try to make the example it works exactly like Excel ... obviously it was operator error on my part... Ugggg thank you again!!! Stay warm
Jenifer