Conditiona Format, Icon Sets, Custom

Kwmck328 · #16 04-06-2023, 08:44 AM

Not a problem... but if you delve into it, let me know what might be possible.

In the meantime.... Have a good day, and Thank you for the help.

Kwmck328 · #17 04-06-2023, 08:56 AM

Quote:

Originally Posted by kilroyscarnival

As far as I can see, yes. That formula is wider than what is displayed there.

The important factor is, does it actually work?

Try plugging in different dates in the original date field (M2).

Exactly 120 days ago today (6-Apr) would be 7-Dec-2022.

116 days ago would be 11-Dec, and 126 days ago 1-Dec. So 127 days ago would be 30-Nov-22.

If you put in those dates you should see the various results expected.

Quote:

Originally Posted by Pecoflyer

To be on the safe side please post a sample sheet with some data ( no pics please). Thx

Hello... I did send an apology for being tardy about acknowledgement of your previous post. Hoping you can help with this "NEW" Work book Sheet, Condition Format Test #1,2,3 ... TEST#3: ICON SET 'Signal Lights' (x3) see attached. I have created this sheet to learn about CF, Test 2 is really a renamed version of test #1 and both work. I would like to see if I can apply the 'ICON SET' to the same rules. Any help would be appreciated or at least point me in a good direction.
Thanks

Kw...

Pecoflyer · #18 04-12-2023, 03:26 AM

Perhaps also acknowledge help received

https://www.msofficeforums.com/excel...-specific.html

Kwmck328 · #19 04-12-2023, 04:58 AM

Hello... I did send an apology for being tardy about acknowledgement of your previous post. Hoping you can help with this "NEW" Work book Sheet, Condition Format Test #1,2,3 ... TEST#3: ICON SET 'Signal Lights' (x3) see attached. I have created this sheet to learn about CF, Test 2 is really a renamed version of test #1 and both work. I would like to see if I can apply the 'ICON SET' to the same rules. Any help would be appreciated or at least point me in a good direction.
Thanks
https://www.msofficeforums.com/attac...1&d=1680796530

Kwmck328 · #20 04-12-2023, 07:05 AM

Hello... I did send an apology for being tardy about acknowledgement of your previous post.... but... sent it to the wrong person

Hoping you can help with this "NEW" Work book Sheet, Condition Format ... TEST#3: ICON SET 'Signal Lights' (x3) see attached. I have created this sheet to learn about CF. I would like to see if I can apply the 'ICON SET' to the rules shown (or something similar).
Any help would be appreciated or at least point me in a good direction.

Again thank you for the input.

Kwm...

Pecoflyer · #21 04-12-2023, 11:35 PM

Post #18 is about another thread on which you did not follow up.

Kwmck328 · #22 04-13-2023, 04:31 AM

Not sure how many times I have to say "Thank You" but here it is again!
Thank you for post # 18
Thank you for post #21
Thank you for the assistance ... it is appreciated

Pecoflyer · #23 04-13-2023, 06:42 AM

OK I give up.

Kwmck328 · #24 04-13-2023, 07:18 AM

As long as you are Happy...

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Custom Style Sets Stopped Working on Custom Template after Recent Microsoft Update	CynthiaKPollard	Word	6	12-20-2021 08:37 PM
RibbonX Editor - change Icon for custom AutoText Gallery	Steve2081	Word	15	04-30-2021 07:58 PM
conditional formatting, icon sets	gohn	Excel	3	06-04-2018 12:15 PM
QuickAccess Toolbar Icon - How to make the icon display the state of the icon's action	ElfegoBaca	Word	1	08-13-2016 08:42 PM
VBA Word - Format ALL Tables - Apply Specific Formatting to Sets of Columns – Font, Border & Width	jc491	Word VBA	10	11-04-2015 04:02 PM