Can I change the format of one cell based on the value of another?
G Gary''s Student Mar 6, 2006 #2 Yes: Say you have text in B1 and a number in A1. You want the value of A1 to decide the format of B1. Select B1 and pull-down conditional formating. Pick Formula is use: =(A1>0) and select a format. if A1 is positive you will see your format.
Yes: Say you have text in B1 and a number in A1. You want the value of A1 to decide the format of B1. Select B1 and pull-down conditional formating. Pick Formula is use: =(A1>0) and select a format. if A1 is positive you will see your format.
