I'm putting a table together and in one column where a date will be I need it to be green until the date expires then it needs to turn red. can anyone help me and explain how I do this?
I'm putting a table together and in one column where a date will be I need it to be green until the date expires then it needs to turn red. can anyone help me and explain how I do this?
Conditional Formatting.
Watch this video
http://www.datapigtechnologies.com/f...rmatexcel.html
Alan עַם יִשְׂרָאֵל חַי
Change an Ugly Report with Power Query
Database Normalization
Complete Guide to Power Query
Man's Mind Stretched to New Dimensions Never Returns to Its Original Form
If the above video doesn't get you going, try these links that deal specifically with conditional formatting for expiration dates
Conditional Formatting Expiration Dates
YouTube - Conditional Formatting Expiration Dates
Palmetto
Do you know . . . ?
You can leave feedback and add to the reputation of all who contributed a helpful response to your solution by clicking the star icon located at the left in one of their post in this thread.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks