How do I gray a cell automatically if another cell has X value?
J Jim May Feb 7, 2006 #2 With Cell A1 Active, at the menu, select Format, Conditional Formatting... and select FormulaIs (from drop-down box) enter into text box =B1=123 select pattern Tab3 Grey OK out Enter in Cell B1 123 Enter in Cell B1 0 HTH
With Cell A1 Active, at the menu, select Format, Conditional Formatting... and select FormulaIs (from drop-down box) enter into text box =B1=123 select pattern Tab3 Grey OK out Enter in Cell B1 123 Enter in Cell B1 0 HTH
