Cell formatting

F

Frank Natalie

I want to change the background color of a cell based upon the results of
different cell in the same row. For example, if c5 = "" then c4 background
color = yellow. Can someone help?

Frank Natalie
 
K

krcowen

Frank

Try setting the Conditional Format of cell c4. Make Condtion 1,
Formula is =C5="" and set the format as you want it.

Good luck.

Ken
Norfolk, Va
 
Top