Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2,420
Default Cell Color condition using IF... ELSE statement in Excel

Only simple ones such as a number < 1000 as an example.

--
__________________________________
HTH

Bob

"Nysh" wrote in message
...
Can we put some conditions in this too?

Plz reply...



On Nov 16, 8:07 pm, "Bob Phillips" wrote:
That is a custom format (CellsFormatCustom ). You could add that to give
a
couple more.

--
__________________________________
HTH

Bob

"Nysh" wrote in message

...
Isn't there any other way?

I had a look on help and found some code like "[red][100];" but didnt
get... how to implement it?

On Nov 13, 1:35 pm, "Bob Phillips" wrote:



CF can handle complex multiple conditions, it can only handle 3 separate
cases per cell unless you have Excel 2007.


--
__________________________________
HTH


Bob


"Nysh" wrote in message


...


I want to change the textcolorof a cell.


The conditional formatting is not what I really seeking for because I
have some complex multiple conditions.


Help me outifyou friends have any solution for me.- Hide quoted text -


- Show quoted text -- Hide quoted text -


- Show quoted text -



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
If, then statement with the condition a blank cell vew Excel Worksheet Functions 10 October 13th 09 06:09 PM
cell color condition Can-Ann Excel Programming 7 January 23rd 08 01:42 AM
counting cell by color and condition Mark Excel Discussion (Misc queries) 1 April 22nd 07 04:56 PM
IF statement and color formatting for cell B1 for condition in A1 Rossta Excel Worksheet Functions 1 July 27th 06 12:37 AM
Using cell color as condition in equation John31 Excel Programming 2 January 7th 04 08:49 PM


All times are GMT +1. The time now is 02:31 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"