color excel

Question

can you help me set formula to color the cell red e and f if blank.&nbsp;for example:a&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;b&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; c&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;d&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; e&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; fItem NumberPart NumberQtyDescRequested DateRequested(Y/N)4part54desc5&nbsp;&nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;

mathetes · Answer

QOne7535&nbsp;&nbsp;All you need to do is select the cells in question and then use Conditional Formatting dialog box to find this;&nbsp;

qone7535 · Answer

thank you. to add for this: can how could i make this color blinking?

mathetes · Answer

I'm not aware that this is even possible. Isn't the red drawing enough attention?

qone7535 · Answer

red drawing is not enough to call attention, because i used color for some cell already. this time, i need blinking for cell requires input or blank cell so that person must enter value on it.

mathetes · Answer

QOne7535&nbsp;red drawing is not enough to call attention, because i used color for some cell already. this time, i need blinking for cell requires input or blank cell so that person must enter value on it.&nbsp;My response to that is multi-fold:(1) you may be using color too much for an input sheet, if you have other cells colored in various ways for anything other than functionality--i.e., if you're doing it because it looks "cool"--then you should de-color those(2) if the red is not distinctive, pick another color(3) train the user(4) re-design the sheet for input

Forum Discussion

color excel

Share

Resources

Item Number	Part Number	Qty	Desc	Requested Date	Requested(Y/N)
4	part5	4	desc5