How do I do a conditional format saying that if A6 has nothing in it then turn J6 a certain colour.
K Kevin May 28, 2009 #1 How do I do a conditional format saying that if A6 has nothing in it then turn J6 a certain colour.
E Eduardo May 28, 2009 #2 Hi, position in cell J6, conditional formating, where the formula is enter a6="" and choose your color
Hi, position in cell J6, conditional formating, where the formula is enter a6="" and choose your color
T T. Valko May 28, 2009 #3 Try this... Select cell J6 Goto the menu Format>Conditional Formatting Select the Formula Is option Enter this formula in the box on the right: =A6="" Click the Format button Select the desired style(s) OK out
Try this... Select cell J6 Goto the menu Format>Conditional Formatting Select the Formula Is option Enter this formula in the box on the right: =A6="" Click the Format button Select the desired style(s) OK out
