Need Help with AND function (cell colour or GANT chart)

C

Cdn_chico

I have tried that after you suggested Dcronje, but have not bee
successful yet, the conditional formatting does allow me to specify th
MONTH function (at least I have not figure it out so far) but I wil
keep trying, thanks for the tip
 
D

dcronje

As an alternative keep the formulas on the sheet and in conditiona
formatting set one condition if CELL = TRUE set the pattern and font t
the same colour you want and set the second condition if cell value
False set the font colour to white.


Let me know if this helps
 
I

Irina

Hi,

Conditional format works pretty well.

Condition 1 = " formula is" =AND(MONTH($B$3)=2,YEAR($B$3)=2003) (cel
with start date)

Condition 2 = " formula is" =AND(MONTH($c$3)=2,YEAR($c$3)=2003) (cel
with end date)

and choose format what do you like.

Try,

Irina
 

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

Top