cell bg color vs. date

D

DKY

Yeah, For example. I click on A1, then I go to Format then t
conditional formatting. I then change the dropdown from cell value i
to formula is. Then I put the formula in there
=AND(A1>=DATE(2004,10,25),A1<DATE(2004,10,27))
and click on the format button on the bottom right/ click on th
Patterns tab, pick my color, and click ok. Then I click ok again t
get out. What am I doing wrong? it doesnt change to the color
picked.
 
F

Frank Kabel

Hi
and what value is in A1?
In your case it should color the cell only for
25-Oct-2004
26-Oct-2004
 

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

Similar Threads

cell bg color vs. date 0
cell bg color vs. date 1
cell bg color vs. date 1
Cells not updated automatically 3
Conditional formatting code 1
Function Help - Forecast Date past due, adjacent cell is blank. Needto highlight the blank cell. 2
Referencing the values of multiple cells in conditinal formatting. 0
Spurious Formula Omits Adjacent Cells 2

Top