Cell formatting

G

Guest

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Changing Cell Color Based on Value 2
format 1
What is the macro to change background based on numeric cell value 2
In Excel is there a function to change a cell's background color? 5
Using the Icon Set for Conditional Formatting 1
Help in color index function 2
Getting a cell to state 1 thing if another cell states something 1
Conditional formatting multiple cells from one cell to another 3

Top