Auto Color

  • Thread starter Thread starter hme
  • Start date Start date
H

hme

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top