Hi All,
Posting to get some help. I googled for a solution and couldn't find one that worked.
I need to highlight in yellow all cells producing a date in a column. So the user either puts in Yes, No, N/A, or a date in a yellow cell. Any guidance would be greatly appreciated. Thanks!
You can use Conditional Formatting for this. Select Conditional Formatting, then New Rule. Choose Use a formula to determine which cells to format, and use this formula. This assumes your data starts in A1:
Then choose your fill color, and click OK. In the Applies to box, select all the cells you'd like to apply the formatting to. Does this do what you're looking for?
Please Login or Register to view this content.
If someone helped achieve your solution, consider clicking "* Add Reputation" on their post.
If your question has been answered, mark the thread as [SOLVED] using the Thread Tools menu at the top of the thread.
Hello! Thanks for the response. It works in terms of highlighting the cell in yellow when I put a date in.
However, when I clear the date out of the cell, the cell remains yellow even though it is blank.
If you will only have text, dates or blanks try
=ISNUMBER(A1)
That works!! Thank you.
Yup, I forgot that once a cell is formatted as a date, forever shall it be! Until you manually change it, that is.
You're welcome & thanks for the feedback
That's okay! It did do the first step I needed haha.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks