Can I format a cell to automatically show a value in red if the value is a negative %?
D David Jul 27, 2005 #1 Can I format a cell to automatically show a value in red if the value is a negative %?
A aristotle Jul 27, 2005 #2 Sure, go to Format->Cells->Number and paste this format in the custom type: 0%;[Red]-0% Regards, A
C Christine Jul 27, 2005 #3 yes- go to Format and select Conditional Formatting. It works like a formula box with IF (cell) is equal/greater/less than than XXXX, then (insert format result- like Font Red)
yes- go to Format and select Conditional Formatting. It works like a formula box with IF (cell) is equal/greater/less than than XXXX, then (insert format result- like Font Red)
