Auto Color
 

Hi


I can not understand why the result of below mentioned formula makes
the cell BLUE.
=IF(AND(O$3=$K8,O$3<=$L8),1,"")

and with another formula as below it makes the cell RED or GREEN or
Brown.

=IF(AND(O$3=$K12,O$3<=$L12),IF($G12="Completed",3 ,IF($G12="In
Progress",2,1)),"")

May somebody explain why are so?

THK

hme


--
hme
------------------------------------------------------------------------
hme's Profile: http://www.excelforum.com/member.php...o&userid=15930
View this thread: http://www.excelforum.com/showthread...hreadid=537999

Auto Color
 

You received the workbook from someone else and you don't know why the cell
is changing colors:

select the cell and look at Format=conditional formatting

Or you don't understand the formulas?

--
Regards,
Tom Ogilvy


"hme" wrote:


Hi


I can not understand why the result of below mentioned formula makes
the cell BLUE.
=IF(AND(O$3=$K8,O$3<=$L8),1,"")

and with another formula as below it makes the cell RED or GREEN or
Brown.

=IF(AND(O$3=$K12,O$3<=$L12),IF($G12="Completed",3 ,IF($G12="In
Progress",2,1)),"")

May somebody explain why are so?

THK

hme


--
hme
------------------------------------------------------------------------
hme's Profile: http://www.excelforum.com/member.php...o&userid=15930
View this thread: http://www.excelforum.com/showthread...hreadid=537999

Auto Color
 

The formulas themselves don't have any effect on the colors. There must be
conditional formatting in the cells you mention. Check under the Format...
Conditional Formatting... menu.
--
- K Dales


"hme" wrote:


Hi


I can not understand why the result of below mentioned formula makes
the cell BLUE.
=IF(AND(O$3=$K8,O$3<=$L8),1,"")

and with another formula as below it makes the cell RED or GREEN or
Brown.

=IF(AND(O$3=$K12,O$3<=$L12),IF($G12="Completed",3 ,IF($G12="In
Progress",2,1)),"")

May somebody explain why are so?

THK

hme


--
hme
------------------------------------------------------------------------
hme's Profile: http://www.excelforum.com/member.php...o&userid=15930
View this thread: http://www.excelforum.com/showthread...hreadid=537999

Auto Color
 

Thanks a lot.

Yes thats right.That is conditional formatting.

How can I use IF function with that? For example :

IF Conditional format is equal to 1 or 2 ' return something ' otherwise
'return something else'

thk

hme


--
hme
------------------------------------------------------------------------
hme's Profile: http://www.excelforum.com/member.php...o&userid=15930
View this thread: http://www.excelforum.com/showthread...hreadid=537999

Auto Color
 

there is no built in support for it. You would have to check the underlying
condition.

You can also look at Chip Pearson's page on this topic:

http://www.cpearson.com/excel/CFColors.htm

--
Regards,
Tom Ogilvy



"hme" wrote:


Thanks a lot.

Yes thats right.That is conditional formatting.

How can I use IF function with that? For example :

IF Conditional format is equal to 1 or 2 ' return something ' otherwise
'return something else'

thk

hme


--
hme
------------------------------------------------------------------------
hme's Profile: http://www.excelforum.com/member.php...o&userid=15930
View this thread: http://www.excelforum.com/showthread...hreadid=537999