David Chapman <[EMAIL PROTECTED]> wrote in news:[EMAIL PROTECTED]:
> For example you want to format B1 based on value of A1 or B1:B10 based > on values of A1:A10 > > In conditional formatting dialog - choose "function is " - then A1=val > or A1:A10=val > > > On 10/30/05, tom <[EMAIL PROTECTED]> wrote: >> >> I would like to change the background color of a cell based upon the >> current contents of a different cell. I've tried the help and can't >> find > a >> way to do it. Can anybody help me? >> >> >> Thanks, >> >> Tom >> >> >> --------------------------------------------------------------------- >> To unsubscribe, e-mail: [EMAIL PROTECTED] >> For additional commands, e-mail: [EMAIL PROTECTED] >> >> > > > -- > My OpenOffice Calc Website > http://www.openofficetips.com > > ------=_Part_25157_15858549.1130714727510-- Thanks. That worked, but it brought up another problem. I first tried the formula $Sheet1.$I13 <> 'Y', but it didn't work so I figured that maybe it didn't like the <>, so I broke down the three cases: (blank), 'Y', and 'N' and used equals signs. 'N' and blank were supposed to yield one style and 'Y' the default style. Blank yielded the correct style. Y yielded the correct style, but since it is the default style I wouldn't know whether it failed, and 'N' yielded the default style, even though it was supposed to yield a different style. I have a feeling that I am putting in the literal values incorrectly. The equation I used was the following: $Sheet1.$I13 = 'N' Can you tell me how to correct it so that when the program sees a capital N in cell I13 it changes the style to my desired value? Thanks, Tom --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
