View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Nysh Nysh is offline
external usenet poster
 
Posts: 3
Default Cell Color condition using IF... ELSE statement in Excel

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 -