On Thu, 2005-09-08 at 12:33 -0500, Irv Cobb wrote: > Randomthots wrote: > > > Irv Cobb wrote: > > > >> I _think_ I can figure out how to do all of the above. However, > >> > >> F. Apply red background to date of last use cell if the song is not > >> available. > >> > >> |date of last use|title|use number| > >> ^^^^^red background > >> > >> G. Apply white background to date of last use cell if the song is > >> available. > >> > >> |date of last use|title|use number| > >> ^^^^^white background > >> > > > > Look up "conditional formatting" in the Help. That should do just the > > trick you want. > > > > Rod > > Thanks, Rod. > > I'm almost there, I think. > > I have this: > > |date of last use|title|use number| formula to determine usability| > > However, it seems that conditional formatting only works on the cell > with the formula in it. I need to change the background color of the > "date of last use" cell based on the results in the "formula to > determine usability" cell. > > Can this be done? >
I am not a Calc guy but I believe so or, I should say, I remember that someone posted something similar to the list. Perhaps a quick search of the list archives will turn it up. -- PLEASE KEEP MESSAGES ON THE LIST. OpenOffice.org Documentation Co-Lead http://documentation.openoffice.org/ --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
