Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course

Use Conditional format to highlight no date

0

Hi Team,

I want to use Conditional format to highlight any cells contains "00-Jan-00". Please advise me on how to do this.

Thank you

excel
MS Office Version: 2007
posted by: fam1r on Mon Oct 30, 2017 at 7:32 am
Answer
Discuss

Discussion

That's not a valid date.
gebobs (rep: 30) Oct 30, '17 at 9:32 am
Sorry, can you please clarify more.
fam1r Oct 30, '17 at 10:05 am
yes it is. and i want to highlight all.
fam1r Oct 30, '17 at 10:05 am
There is no zeroth of January.
gebobs (rep: 30) Oct 30, '17 at 11:45 am
Add to Discussion

Answers

0

Select A1. Set conditional formatting by selecting "Use a formula to determine which cells to format". Use this formula.

=A1="00-Jan-00"

You can copy the format from A1 to anywhere else or set the "Applies to" range for the CF in the CF manager's dialog box to indicate the range you need.

posted by: Variatus (rep: 4889) on Mon Oct 30, 2017 at 10:18 pm
Discuss


Answer the Question

You must create an account to use the forum. Create an Account or Login