Posted to microsoft.public.excel.worksheet.functions

Walley

external usenet poster

Posts: 12

ISNA Function

Hi
I use IF(ISNA(LOOKUP(1100;C6:C25));"";(LOOKUP(1E+100;C6: C25)-C6)*1200)
function and I apply Conditional formating with Icon set to fill the cell
with green color if the value 0, red if < 0 and yellow if 0, it work, but
when the cell is empty it fill with green color. If there is any way to leave
the color of the cell unchanged
if the cell empty.
Thank

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?ISNA?MATCH? Function?	handyaccountant	Excel Discussion (Misc queries)	2	October 2nd 08 06:33 PM
Vlookup - ISNA function	Eduardo	Excel Discussion (Misc queries)	4	September 24th 08 06:10 PM
ISNA match function help	Adam	Excel Worksheet Functions	9	March 8th 08 03:24 AM
ISNA function	[email protected]	Excel Discussion (Misc queries)	3	August 16th 07 01:24 AM
example if IF(ISNA()) function	Gus	Excel Worksheet Functions	8	November 24th 04 05:27 PM

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

About Us

"It's about Microsoft Excel"

Menu

About Us