LinkBack URL
About LinkBacks
kisboros 
Somehow I never find the exact scenario for my problems., so here it is:
If E2 contains a date, I want to color P2.
Thank you!
Somehow I never find the exact scenario for my problems.
If E2 contains a date, I want to color P2.
Thank you!
Is there anything else that can be in E2? If only a date or text or blank, then use:
Select Formula Is and enter formula:
=ISNUMBER(E2)
Where there is a will there are many ways.
If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below left corner
Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.
I often need to use this action when I am referring to another cell. And no, it doesn't have anything else in it other than text, date , or a number. Thank you for the help!
So is it solved?
Yes, thank you.
Great... just wanted to make sure it wasn't left hanging...
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks