Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old February 1st 21, 04:36 PM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Apr 2011
Posts: 3,848
Default Hello! I'm a newbie to this forum from Adelaide, South Australia.

Hi Ron,

Am Mon, 4 Jan 2021 15:30:56 +0000 schrieb ron.hume:

I have a budget worksheet using Excel 2013 15.0.5301.1000 32 bit.
The left column contains fortnightly dates, each date row has income,
expenses and a balance.
I highlight the current date row with a colour fill manually, but I want
to fill the row of the next date automatically as the current date
changes.
Can someone give me a step by step way to do that or at least give me a
clue?
I imagine the IF thing may be useful to compare dates.


select your table from A1 to D and the end = Conditional Formatting =
and enter there the formula:
=ROW()=MATCH(TODAY(),$A$1:$A$500,1)+1
and choose the expected interior color.


Regards
Claus B.
--
Windows10
Microsoft 365 for business

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Office DevCon in Australia Graham R Seach MVP Excel Discussion (Misc queries) 1 October 12th 09 03:43 PM
Office DevCon in Australia Graham R Seach MVP Excel Programming 1 October 12th 09 03:43 PM
How do I repesent statistics on the map of Australia using MS MAP Richard ITHIER Charts and Charting in Excel 1 September 6th 05 07:35 AM


All times are GMT +1. The time now is 02:11 AM.

Powered by vBulletin® Copyright ©2000 - 2021, Jelsoft Enterprises Ltd.
Copyright 2004-2021 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017