Conditional Formatting Issue

[Newbienew]

I am having 2 issue with my conditional format formula.

I am trying to work out a formula that allows me to detect new entries daily. So what if i put an entry in today tomorrow it would be gone until a new entry was made that day. Below is what i have already but it seems to be constant


my second issue is

So on the whole sheet this formula is running =IF(A1<>"",IF(B1<>"",B1,NOW()),"") with the fill color green. (any new entry

In Columns F and G I am running this code
=COUNTIFS($F$2:$F$100,$F2,$G$2:$G$100,$G2)>1 (detect duplicates in both columns) range is F2:G10 for testing in red

in column F turns green but then goes no fill when something is placed in the adjacent cell of G. But G will turn green.
Instead of both turning green. Unless its a duplicate then it turns red.
Is there anything that i can do

 

[etaf]

i dont understand how this is working as a conditional format formula
=IF(A1<>"",IF(B1<>"",B1,NOW()),"")

Conditional formatting required a TRUE or a FALSE ( But will also use a number Zero = false and number will be seen as a TRUE )
so i dont understand the use of NOW()
As NOW() is a decimal part of 1 - it will still be positive for times
it will not respond to letters

 

[Newbienew]

What it allows me to do is any entry I put in any cell will be highlighted. But it will not stop and will remain each day

 

[etaf]

do you put the date in of the entry |?

lets see if i understand not sure I do
its today 7th April and in cell G4 you enter some values - text or numbers AND NO date
you then want that to highlight until you put a new entry in cell G4 and then it does not highlight
OR
you put a entry in G4
and then it stays highlighted until a new entry is put in G5 regardless of when that is entered

as i say not really clear on what you want to happen

 

[Newbienew]

Ah ok, so as today is the 7th April an entry would be placed in G4 and be highlighted. When the next day comes 8th April the highlighted entry from the 7th would no longer be highlighted. The entries on the 8th of April would be highlighted. So its much like same day highlighting it what I am looking for.

 

[etaf]

but are you also putting the date into a cell - or just other data
If latter, I dont know how to do that without possibly a macro that records the date of entry and uses that info VBA is not something i can answer here

 

[Newbienew]

Any data. Right now it works with the formula but it will just stay highlighted.

 

[etaf]

yep, it will sort of work , but not correctly , all is doing is turning the cell TRUE in conditional formatting
as i mentioned NOW() is a number and any number will be seen as TRUE in conditional formatting
its NOT using the time , just the number
without a date stamp or vba , excel does NOT know when you entered something

How from the sheet do you know what date the spreadsheet had data entered into a cell ?

 

[Newbienew]

Thats the issue. So the work book gets sent out daily and the review wants to see everything that was entered for the day in green. and everything that was changed in orange. I was going to use this formula to do that but, as you see it is continuous. So, it would appear every day something new and something changed was on the worksheet even if it was the day before or the day before that.

 

[etaf]

ok, i did something like this years and years ago , with a VBA macro, created a reference sheet and then using the reference sheet would identify any cells that had changed
it was a sales tracker for Europe , so we could see the changes to forecast each week at a sales review.
BUT , that was a very old I think 2003 version of excel and I nolonger have a copy
i think thats maybe the sort of thing you want
But i have not used VBA for years
maybe worth posting a new thread - with a different request, as you just described