P pcorcele Feb 24, 2012 #1 How do I go about telling cell q7 backgound to be RED when q6 cell is less that zero Thanks
G Gord Dibben Feb 24, 2012 #2 Select Q7 and Format>Conditional Formatting>Formula is =$Q6<0 Format to red and OK Gord
