Remove conditional formatting after 60 days

[SiRhOSEven]

Hi to all,

I'm want to create an excel file in which it will automatically remove the conditional formatting after certain days.
Is this possible?


Regards,

 

[etaf]

you could add to the rule an
AND ()
if you have a date cell anywhere in the spreadsheet - so it can compare today()
with a date - otherwise it will not know the 60 days

do you have any dates in the spreadsheet you could use - OR you could setup a date as a reference and change that date

=AND( cell > today() - 60 , other conditional formatting rule )

 

[SiRhOSEven]

you could add to the rule an
AND ()
if you have a date cell anywhere in the spreadsheet - so it can compare today()
with a date - otherwise it will not know the 60 days

do you have any dates in the spreadsheet you could use - OR you could setup a date as a reference and change that date

=AND( cell > today() - 60 , other conditional formatting rule )

I'm thinking of creating a new column(for example column B) beside it(column A) and it will be populated with date when data on column A changes but I don't know how to do it.

Also, these dates(when data on column A changes) should not update(it should be fixed) when I open the workbook the next day.

I think I need to start with creating a vba code that timestamp on column B when data on column A changes but I don't know how to do it. Can you help me with that?

 

[etaf]

no, i dont vba to do a timestamp when data changes - sorry, but it has been asked for before
https://www.mrexcel.com/forum/excel...t-change.html?highlight=timestamp+data+change

 

[SiRhOSEven]

no, i dont vba to do a timestamp when data changes - sorry, but it has been asked for before
https://www.mrexcel.com/forum/excel...t-change.html?highlight=timestamp+data+change

Hi etaf, can you please share with us how to do timestamp when data changes without vba? Thank you so much.

 

[etaf]

Hi etaf, can you please share with us how to do timestamp when data changes without vba?

no, i dont vba to do a timestamp when data changes

i Dont Know how to do VBA - sorry ,

hence the link to a thread that does know

 

[SiRhOSEven]

i dont vba to do a timestamp when data changes

What I understand when you say this is that "I use another technique/trick to do timestamp when data changes" that's why I ask you how to do timestamp without using vba. Anyway. Thanks for the help.

 

[etaf]

no, sorry - i know how to date stamp once , when data added - but not changed each time