Conditional Formating Problem
Hi everyone,
And again I need your help. I have to admit I am not so familiar with conditional formatting and probably I misunderstood the concept. In cell C69 I choose 'Condition Formating' and choose 'FORMULA IS' and wrote this formula =IF($C$70$N$70,) 'CONDITIOAL FORMATING TO TEXT COLOUR RED' but notthing happened. What did I do wrong? Thank You Albert |
Conditional Formating Problem
In Formula Is, you need a formula that evaluates to either TRUE or FALSE
So you would use =$C$70$N$70 Then click the Format button on the Conditional Formatting dialog and select font colour red Have a look at Deborah's site: http://www.contextures.com/xlCondFormat01.html -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "albertmb" wrote in message ... Hi everyone, And again I need your help. I have to admit I am not so familiar with conditional formatting and probably I misunderstood the concept. In cell C69 I choose 'Condition Formating' and choose 'FORMULA IS' and wrote this formula =IF($C$70$N$70,) 'CONDITIOAL FORMATING TO TEXT COLOUR RED' but notthing happened. What did I do wrong? Thank You Albert |
Conditional Formating Problem
Thank You Bernard, I thought I was doing something wrong, now it worked
perfectly. Regards Albert "Bernard Liengme" wrote: In Formula Is, you need a formula that evaluates to either TRUE or FALSE So you would use =$C$70$N$70 Then click the Format button on the Conditional Formatting dialog and select font colour red Have a look at Deborah's site: http://www.contextures.com/xlCondFormat01.html -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "albertmb" wrote in message ... Hi everyone, And again I need your help. I have to admit I am not so familiar with conditional formatting and probably I misunderstood the concept. In cell C69 I choose 'Condition Formating' and choose 'FORMULA IS' and wrote this formula =IF($C$70$N$70,) 'CONDITIOAL FORMATING TO TEXT COLOUR RED' but notthing happened. What did I do wrong? Thank You Albert |
All times are GMT +1. The time now is 02:27 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com