Highlight the upcoming transaction
Hi guys, I want use conditional formatting to highlight the upcoming transaction but I can't figure out the formulae to do it. For example, today is 28 Jan 2019, transaction will be highlight if I entered the transaction which is happen after 28 Jan 2019. Any solution on it?
Last edited by alferd324; 01-28-2019 at 11:19 PM.
Select the range
I have used
$C$4:$AG$74
=AND(C$3>TODAY(), C4<>0)
however that does muck up your total fill colours
so you could set up different ranges to keep it tidy
Wayne
if my assistance has helped, and only if you wish to , there is an "* Add Reputation" on the left hand side - you can add to my reputation here
If you have a solution to your thread - Please mark your thread solved do the following: >
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.
Hi
Select the range to highlight, then Conditional Formatting>New Rule >Use Formula to determine.....
Formula =INDIRECT(ADDRESS(3,COLUMN()))=TODAY()
apply formatting as required
It is works as expected. Thanks for your help.
Hi, is there possible to still keep the highlighted cell highlight even though the transaction already past. For example, today is 29 Jan 2019, when I entered transaction for 30 Jan 2019 and it will be highlight. But this highlight still keep remain when tomorrow or day after tomorrow. In other words, it will not change once it had been highlighted unless user change it manually
i think you may need VBA to do that ( not my area )
If a transaction has been entered sometime in the future you want those transactions that have been entered in the future to always be highlighted
Conditional formatting as i set out , will only look at the instant at not take into account what had happened maybe days ago.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks