Hello:

I have been trying to use what I thought would be a simple formula to change the color of one cell based on text in that cell and having text in the first cell of the same row. Using conditional formatting, I thought of using a formula in A2 as follows: =AND(ISTEXT(A1),ISTEXT(A2)) but it doesn't seem to work. Also, if and when the formula may work I would want to copy it across the row keeping A1 constant and changing A2 to A3,A4,A5,etc.... Any help would be GREATLY appreciated.