ATAR Notes: Forum

VCE Stuff => VCE Technology => VCE Mathematics/Science/Technology => VCE Subjects + Help => VCE Computing: Data Analytics => Topic started by: billz1508 on August 10, 2009, 09:06:51 pm

Title: formular for highlighting a cell..
Post by: billz1508 on August 10, 2009, 09:06:51 pm

is it possible for a formula to be highlighted is a figure is less than ###.

e.g.    cell  a1: "jim croger"        has paid $$       if paid 30 dollars highlight cell a1?

so this means the jim croger will be bvold or different colour or something? is this possible..

Title: Re: formular for highlighting a cell..
Post by: danieltennis on August 10, 2009, 09:10:59 pm

Yeah, you can use conditional formating for that.  

Title: Re: formular for highlighting a cell..
Post by: billz1508 on August 10, 2009, 09:12:17 pm

thankyou :)