need help

[bam12]

I need some help with this but not sure how to explain it

I have to check a cell to see if ti has a date in it, if so , then i have to check the current date to another cell, if the current date is greater then that cell i want to change the color of the cell

Not sure what formula to use

 

[mordrid]

Hi I am a bit confused now. I thought you wanted to check the date in the cell against todays date and then change the cell colour if your date was was beyond todays date. i.e. it would be green if date was 1st Aug etc.

With conditional formatting you do not put the value in the cell but in the conditional formatting box. I can't appear to insert a pic so if you look at sthack99,s post where it says Formula IS with an arrow next to it click on the arrow and select cell value is, two other boxes will then appear to the right (where the single formula box is) in the first 1 select the condition and in the second place =TODAY(). As I mentioned though I think you will need 2 conditions (use the add button to get another one up) for the normal state.

Once conditional formatting is set it will only work when you place a date in the appropriate cell the formatting will then either remain as is or change depending on the date entered

Regards
Richard

 

[bam12]

sorry

in his example he places today date in a cell, which i am not doing

 

[mordrid]

Just try what I am suggesting as I explained before TODAY () is a standard excel function that picks up todays date

 

[bam12]

i tried it but i guess i am using the wrong cells or something

 

[mordrid]

I have sent you a pm

 

[sthack99]

It worked for me. Remember, don't enter the formula directly in the cell. Use it in conditional formatting, and only in column H, making sure the cell references match the row each cell is on.

 

[bam12]

more

i appreciate all th ehelp i got with this. I got it working somewhat, the way I want

Was wondering if i can check column I to see if it has date in it and if so not to do the conditional formatting