View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Bob Phillips[_3_] Bob Phillips[_3_] is offline
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 -