Cell formatting
 

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

Cell formatting
 

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


On Oct 5, 12:36 pm, Frank Natalie <Frank
wrote:
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

Cell formatting
 

Thanks Ken for the help, it worked perfectly....

Frank Natalie

" wrote:

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


On Oct 5, 12:36 pm, Frank Natalie <Frank
wrote:
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