VBA or Condtional Formatting

**persais** · 08-16-2012, 10:35 AM

Hello,

so I've never done this kind of formula and am not sure if it can even be formatted, it may have to be VBA... what I would like is this:

if column D5 rows 5-48 do nothave two entries of 2012 then highlight D4:G4 row 5.

I really hope that makes sense!

**dilipandey** · 08-16-2012, 10:55 AM

Hi Persais,

Entries of 2012 ? Would it be 2012 or any date of year 2012 ?

Regards,
DILIPandey

<click on below 'star' if this helps>

**persais** · 08-16-2012, 10:56 AM

yes, thats true, a date of 2012

**dilipandey** · 08-16-2012, 10:58 AM

Also

then highlight D4:G4 row 5.

??

D4:G4 already have row 4.. it can't be row 5 ?

Please share the criteria clearly.. may be like if D5:D48 has any date of year 2012 then highlight the range D4:G4 .. Thanks.

Regards,
DILIPandey

<click on below 'star' if this helps>

---------- Post added at 08:28 PM ---------- Previous post was at 08:27 PM ----------

Ok.. Please reply to my post#4 as well.. thanks

Regards,
DILIPandey

<click on below 'star' if this helps>

**persais** · 08-16-2012, 11:02 AM

Sorry - trying to make sense. D5:D48 has any date of 2012 two times then highlight range D4:G4 sounds right

**dilipandey** · 08-16-2012, 11:13 AM

Hi Persais,

Use the below formula in conditional formatting logic :-

Formula:

Please Login or Register  to view this content.

See attached:- CF if two dates in 2012 year.xlsx

Regards,
DILIPandey

<click on below 'star' if this helps>

**persais** · 08-16-2012, 11:37 AM

thats awesome, thank you so much!!! is there a way to make it highlight if there are less than 2 dates of 2012? I think I explained it wrong above, so if there are less than 2 entires for 2012 I want it to highlight so its noticable...

woulc I just change the > symbol?

=(SUM(--(YEAR($D$5:$D$48)=2012)))<=2

**dilipandey** · 08-16-2012, 11:53 AM

Yes... try playing with < > symbols ...

Regards,
DILIPandey

<click on below 'star' if this helps>

**persais** · 08-16-2012, 11:57 AM

Thank you so much! you are wonderful!

**dilipandey** · 08-16-2012, 12:01 PM

You are welcome...

Cheers

Regards,
DILIPandey

<click on below 'star' if this helps>

VBA or Condtional Formatting

LinkBack

Thread Tools

Rate This Thread

Display

VBA or Condtional Formatting

Re: VBA or Condtional Formatting

Re: VBA or Condtional Formatting

Re: VBA or Condtional Formatting

Re: VBA or Condtional Formatting

Re: VBA or Condtional Formatting

Re: VBA or Condtional Formatting

Re: VBA or Condtional Formatting

Re: VBA or Condtional Formatting

Re: VBA or Condtional Formatting

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions