ExcelBanter - Conditional formatting

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Conditional formatting (https://www.excelbanter.com/excel-programming/445434-conditional-formatting.html)

pcorcele

Conditional formatting

How do I go about telling cell q7 backgound to be RED when q6 cell is
less that zero
Thanks

Gord Dibben[_2_]

Conditional formatting

Select Q7 and FormatConditional FormattingFormula is

=$Q6<0

Format to red and OK

Gord

On Fri, 24 Feb 2012 06:08:30 -0800 (PST), pcorcele
wrote:

How do I go about telling cell q7 backgound to be RED when q6 cell is
less that zero
Thanks

All times are GMT +1. The time now is 11:17 AM.