Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formating Problem | Excel Discussion (Misc queries) | |||
Conditional Formating | Excel Discussion (Misc queries) | |||
Conditional Formating Problem | Excel Discussion (Misc queries) | |||
formating problem, PLEASE help. | Excel Discussion (Misc queries) | |||
Install dates formating using conditional formating? | Excel Discussion (Misc queries) |