Nov 10, 2017 · Icon sets are discussed in my book, Power Excel with MrExcel. Click that “i” in the top-right hand corner to check. Alright, wrap- up of this quick episode: Can you apply …

Method 2 You can use the icon sets but you must set up the parameters on a per column (subtotal) basis. You will click in the February sub total column and apply the Conditional …

Aug 11, 2010 · Hi all, I have a question with regards to using Conditional Formatting Icon Set. I currently use Excel 2007 and they have added the Conditional Formatting tool which is really …

Jul 2, 2013 · SpencerS S C Conditional Formatting Icon Sets Based on Letters Rather than Numbers CRSHFBRCTN Aug 9, 2025 Excel Questions Replies 4 Views 382 Aug 10, 2025

Sam 31 1 1 3 1 It depends of Excel if you have Excel-2010 and more you can do it by customizing the set but for Excel 2007 you have to use the available colors and sequences Red, Yellow, …

Aug 26, 2011 · I checked the threads and couldn't find an answer. Can you create custom icon sets to use with Conditional Formatting? If so how? Thanks for your time

Mar 19, 2023 · Hi, Could anyone help me out with the following? I have a table with dates that I would like to highlight with shape icon sets (green, red & yellow circles) depending on the date …

Feb 17, 2010 · Now apply two Conditional Formatting rules to Cell C1: =C1=CHAR (234) as the formula to format the font as Bold and Green =C1=CHAR (233) as the formula to format the …

Aug 18, 2017 · Icon Sets With the same range selected, now select Home, Conditional Formatting, Manage Rules, Edit Rule. Check the Show Icon Only checkbox. Show Icon Only …

Apr 14, 2011 · Jun 3, 2025 RoryA A Conditional formatting icon sets for expiry 12months from date in cell adamtaylad Sep 19, 2024 Excel Questions Replies 6 Views 1K Sep 20, 2024