Posted to microsoft.public.excel.programming

David

external usenet poster

Posts: 1

ActiveCell.Formula and IF statement

Hi,

Could I get a hand interpreting this code?? I gather that IF is an
alias for IIf with the syntax: IIf(expr, truepart, falsepart)

ActiveCell.FormulaR1C1 =
"=IF(RC[-1]=0.04,IF(RC[-1]=0.05,""Substantial"",""Alert""),IF(RC[1]=""
"",""No"",""Alert""))"

I want to modify this so when the expression evaluates to
"Substantial" the whole row is highlighted too. Any ideas?

Cheers!

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
If activecell.column = variable then activecell,offset (0,1)	Battykoda via OfficeKB.com	Excel Discussion (Misc queries)	1	October 2nd 07 08:05 PM
ActiveCell.Formula Syntax	Notorious_F.A.T	Excel Programming	2	April 5th 04 10:15 AM
activecell.formula syntax	Larry Levinson	Excel Programming	4	December 23rd 03 01:33 PM
Whats wrong with this VBA statement -ActiveCell.FormulaR1C1...?	hal	Excel Programming	5	November 8th 03 02:48 AM
Formula with an ActiveCell	Sok Hong	Excel Programming	3	August 14th 03 08:24 AM

All times are GMT +1. The time now is 08:30 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us