Home
What's new
Latest activity
Authors
Store
Latest reviews
Search products
Forums
New posts
Search forums
What's new
New posts
New listings
New products
New profile posts
Latest activity
Members
Current visitors
New profile posts
Search profile posts
Log in
Register
Cart
Cart
Loading…
What's new
Search
Search
Search titles only
By:
New posts
Search forums
Search titles only
By:
Menu
Log in
Register
Navigation
Install the app
Install
More options
Change style
Contact us
Close Menu
Forums
SVTPerformance's Chain of Restaurants
Road Side Pub
Excel formula help
JavaScript is disabled. For a better experience, please enable JavaScript in your browser before proceeding.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an
alternative browser
.
Reply to thread
Message
<blockquote data-quote="Teethy" data-source="post: 11431303" data-attributes="member: 82108"><p>...And then pick a cell that you don't need and type =Today() and use conditional formatting to format the column that has the return call date to turn a cell red if the date for return call is in the past based on the current date cell. That formula will look something like this...</p><p></p><p>=IF(M2<$M$53,TRUE,FALSE)</p><p></p><p>M2 will be the cell being formatted. M53 is set absolute and is always referenced as todays date. The true condition will be whatever you set the format as. False can be formatted differently or not at all.</p><p></p><p>Hope this helps.</p></blockquote><p></p>
[QUOTE="Teethy, post: 11431303, member: 82108"] ...And then pick a cell that you don't need and type =Today() and use conditional formatting to format the column that has the return call date to turn a cell red if the date for return call is in the past based on the current date cell. That formula will look something like this... =IF(M2<$M$53,TRUE,FALSE) M2 will be the cell being formatted. M53 is set absolute and is always referenced as todays date. The true condition will be whatever you set the format as. False can be formatted differently or not at all. Hope this helps. [/QUOTE]
Insert quotes…
Verification
Post reply
Forums
SVTPerformance's Chain of Restaurants
Road Side Pub
Excel formula help
Top