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 -
|