IEW Posted August 24, 2005 Share Posted August 24, 2005 Find number of days between two dates. (Got it) If days are greater that 15: Change color of 15 and greater to red. Can this be done in one calculation? IW Link to comment Share on other sites More sharing options...
sbg2 Posted August 26, 2005 Share Posted August 26, 2005 Let([x = Date2 - Date1; y = If(x < 15; x ; TextColor (x ; RGB ( 255 ; 0 ; 0 )))]; y) Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 6677 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now