Hi use 'format - conditional Format' for this
C cookie Nov 11, 2004 #2 If the word Promotion is in cell A1, then the cell C5 needs to change? conditional format only allows me to do it if I were in A1 - doesn't it
If the word Promotion is in cell A1, then the cell C5 needs to change? conditional format only allows me to do it if I were in A1 - doesn't it
F Frank Kabel Nov 11, 2004 #3 Hi - select C5 - goto the conditional format dialog - choose 'formula' from the dropdown - now enter =$A$1="Promotion" - choose your format
Hi - select C5 - goto the conditional format dialog - choose 'formula' from the dropdown - now enter =$A$1="Promotion" - choose your format
C cookie Nov 11, 2004 #4 Fantastic, yet again you've helped me. Frank Kabel said: Hi - select C5 - goto the conditional format dialog - choose 'formula' from the dropdown - now enter =$A$1="Promotion" - choose your format Click to expand...
Fantastic, yet again you've helped me. Frank Kabel said: Hi - select C5 - goto the conditional format dialog - choose 'formula' from the dropdown - now enter =$A$1="Promotion" - choose your format Click to expand...
