Conditiona Format, Icon Sets, Custom

Kwmck328 · #1 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...

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