SOLVED
Home

Challenging Conditional Formatting Question

%3CLINGO-SUB%20id%3D%22lingo-sub-394487%22%20slang%3D%22en-US%22%3EChallenging%20Conditional%20Formatting%20Question%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-394487%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20all%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20a%20spreadsheet%20used%20for%20project%20management.%20In%20one%20column%20I%20have%20%22Deadline%20Agreed%22%20data%2C%20which%20basically%20contains%20a%20date%20dd%2Fmm%2Fyy%26nbsp%3B(if%20agreed%20with%20a%20counterparty)%20or%20if%20a%20date%20hasn't%20been%20agreed%2C%20the%20cell%20may%20be%20blank%20or%20contain%20text.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI'm%20looking%20for%20a%20method%20of%20conditional%20formatting%20this%20column%20to%20highlight%20any%20cells%20where%20a%20deadline%20hasn't%20been%20agreed%20(i.e.%20the%20cell%20is%20blank%20or%20has%20text%20in).%20Would%20any%20of%20you%20genuises%26nbsp%3Bbe%20able%20to%20help%20with%20this%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EMany%20thanks%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ERoxo%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-394487%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EConditional%20Formatting%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-394565%22%20slang%3D%22en-US%22%3ERe%3A%20Challenging%20Conditional%20Formatting%20Question%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-394565%22%20slang%3D%22en-US%22%3EYou%E2%80%99re%20right.%20It%E2%80%99s%20not%20really%20challenging%2C%20only%20if%20you%20know%20the%20function%20that%20is%20appropriate%20for%20your%20situation.%20Anyway%2C%20I%E2%80%99m%20glad%20to%20have%20helped%20you.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-394524%22%20slang%3D%22en-US%22%3ERe%3A%20Challenging%20Conditional%20Formatting%20Question%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-394524%22%20slang%3D%22en-US%22%3E%3CP%3EPerfect%20just%20tried%20this%20and%20its%20worked%20%3A)%20Maybe%20wasn't%20that%20challenging%20after%20all!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%20for%20your%20help!!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-394519%22%20slang%3D%22en-US%22%3ERe%3A%20Challenging%20Conditional%20Formatting%20Question%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-394519%22%20slang%3D%22en-US%22%3E%3CP%3ESelect%20the%20cells%20you%20want%20to%20conditionally%20format%20and%20enter%20this%20conditional%20formatting%20formula%3A%3CBR%20%2F%3E%3DNOT(ISNUMBER(A2))%3CBR%20%2F%3EThe%20foregoing%20formula%20assumes%20that%20your%20dates%20start%20in%20A2.%3C%2FP%3E%3C%2FLINGO-BODY%3E
R-o-x-o
Occasional Contributor

Hi all,

 

I have a spreadsheet used for project management. In one column I have "Deadline Agreed" data, which basically contains a date dd/mm/yy (if agreed with a counterparty) or if a date hasn't been agreed, the cell may be blank or contain text.

 

I'm looking for a method of conditional formatting this column to highlight any cells where a deadline hasn't been agreed (i.e. the cell is blank or has text in). Would any of you genuises be able to help with this?

 

Many thanks,

 

Roxo

3 Replies
Solution

Select the cells you want to conditionally format and enter this conditional formatting formula:
=NOT(ISNUMBER(A2))
The foregoing formula assumes that your dates start in A2.

Perfect just tried this and its worked :) Maybe wasn't that challenging after all!

 

Thanks for your help!!

You’re right. It’s not really challenging, only if you know the function that is appropriate for your situation. Anyway, I’m glad to have helped you.
Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
16 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
11 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies