LinkBack URL
About LinkBacks
Hi all, how can I condition format a cell to show no format if the cell contains a date
Please see the attached book1.xlsx for more info
Thanks for your help
Book1.xlsx
Hi all, how can I condition format a cell to show no format if the cell contains a date
Please see the attached book1.xlsx for more info
Thanks for your help
Book1.xlsx
Last edited by xWiZardx; 05-03-2014 at 12:17 PM.
Try using
=CELL("format",D10)<>"D1"
see here
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.
Use a formula instead of just checking the value in the cell.
Formula:
Please Login or Register to view this content.
Regards, TMS
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
etaf's formula checks the specific date format. I was trying to generalise in case you change the format.
Regards, TMS
Thank you TMS,
I tried changing the cell format to "Date" and using the formula you provided but the conditional formatting doesn't activate, can you please take a look?
Thanks a lot
Book2.xlsx
Try this, with a slight amendment to the CF formulae.
Formula:Please Login or Register to view this content.
Formula:Please Login or Register to view this content.
Formula:Please Login or Register to view this content.
I also copied and pasted the format from the first cell to the others ... but then made some General
Regards, TMS
Hmm... still the same when I format the cell to "Date"
But thanks anyway, I'll just format those cells to "custom"
If you start with a cell that is formatted as General and type in a string that Excel recognises as a date, it will automatically change the format of the cell to Date and, typically, it wii copy the format from previous rows.
Regards, TMS
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks