Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 54
Default Keeping format Data returned in IF Statement

Hi
Please can you help with this.
I have an if statment and when the data is returned to the Cell, I want the
exact formatting of the data that is where it is coming from.
Thanks
Anne
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 136
Default Keeping format Data returned in IF Statement

Not possible with functions, you would need an event macro

--


Regards,


Peo Sjoblom


"enna49" wrote in message
...
Hi
Please can you help with this.
I have an if statment and when the data is returned to the Cell, I want
the
exact formatting of the data that is where it is coming from.
Thanks
Anne



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

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
Sorting Data and Keeping format of rows Luci Excel Discussion (Misc queries) 0 May 24th 07 06:38 AM
Data Validation - List - keeping the format of the list - shading aasbury Excel Discussion (Misc queries) 1 June 5th 06 04:25 PM
Format numbers returned in the function CONCATENATE Kip Excel Discussion (Misc queries) 3 April 5th 06 06:59 PM
No value returned in if statement Shellack Excel Worksheet Functions 3 March 23rd 06 07:49 PM
How do I set up a conditional format using the value returned by . RGDeb Excel Discussion (Misc queries) 2 April 26th 05 12:59 PM


All times are GMT +1. The time now is 01:13 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"