Example:
If B1 (random date) ages past thirty days (Today's date + 30 days) I want to change the entire row with the information to red/white
Date cell is reading true instead of original date
Example:
If B1 (random date) ages past thirty days (Today's date + 30 days) I want to change the entire row with the information to red/white
Date cell is reading true instead of original date
Last edited by Rocky Williams; 12-30-2014 at 03:57 PM.
for 2007 or 2010 excel version
Conditional Formatting
Highlight applicable range >>
B1:B9
Home Tab >> Styles >> Conditional Formatting
New Rule >> Use a formula to determine which cells to format
Edit the Rule Description: Format values where this formula is true:
=$B$9 > today()+30
Format… [Number, Font, Border, Fill] Format to fill Red and Font colour white
choose the format you would like to apply when the condition is true
OK >> OK
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.
How do I stop the date cell from reading TRUE and how do I make the applicable to the whole sheet?
you change the range to apply to the whole sheet - rather than B1:B9
that will then highlight the whole row
BUT
Please upload a sample of your workbook to the forum, Make sure you have removed any private information, remember this is a public forum and so available to anyone
Would like to see an example of your data and also a manual mock up of the expected results you want to achieve.
To attach a file to your post,
click "Go advanced" (next to quick post),
scroll down until you see "manage Attachments",
click that and select "add files" (top right corner).
click "select files" find your file, click "open" click "upload" click 'done" bottom right. click "submit reply"
Once the upload is completed the file name will appear below the input boxes in this window.
You can then close the window to return to the new post screen.
Sample is attached as requested.
use
=AND($F4<TODAY()-30, $F4<>"")
and apply to range
A4:F1000 or however, many rows you need to apply to
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks