Windows XP Microsoft Office Excel 2003 SP3
Here is what I am trying to do; Cell A7 is set up as an entry cell. Cell E7 is the target cell.
If cell A7 is blank, the phrase is E7 “Labor per Hour” appears in black font. If there is an entry in A7, I want the font to be in blue. What I have tried; In cell E57 I entered the phrase “Labor per Hour” with black font and cell E58 I entered the same text in blue font and in cell E7 entered the formula =IF(A7=0,E57,E58). It works except it does not bring the color change. Can it be done some way? Maybe something that will just change the font color.
Moree if you get this Hi from Colorado USA and as always Thank you for your help.