Can a cell that is formated for percentage be red if the percentage is negative
S SteveW Feb 1, 2006 #1 Can a cell that is formated for percentage be red if the percentage is negative
B Bernard Liengme Feb 1, 2006 #2 Hi Steve 1) with custom format 0%;[Red]0% OR 2) using Format |Condition Format; Formula is A1<0 ... format font or background to red best wishes
Hi Steve 1) with custom format 0%;[Red]0% OR 2) using Format |Condition Format; Formula is A1<0 ... format font or background to red best wishes
B Bob Phillips Feb 1, 2006 #3 Yeah, just set a custom format of 0%;[Red]0%;0% -- HTH Bob Phillips (remove nothere from email address if mailing direct)
Yeah, just set a custom format of 0%;[Red]0%;0% -- HTH Bob Phillips (remove nothere from email address if mailing direct)
