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
