Quote:
Originally Posted by pcorcele
How do I go about telling cell q7 backgound to be RED when q6 cell is
less that zero
Thanks
|
Hi
If u r using Office 2007 onwards
use the conditional format
Select conditional format
Select new rule
Select use a formula to determine which cell to format
then in the formula bar just as example
Cell d4 is selected
in the formula bar click on cell c4<0
format fill red color
Thanks may this help
Bakar