conditionally format

Conditional formatting based on a column and TC Name. Example table below: <tbody> TC Name Project Ave Load TC1 0 0% TC2 25 218% TC3 7 44% TC4 16 114% </tbody> So I was giving a R/Y/G fill for the percentages in the "Ave Load" column based on the TC name (because they can be...

Hi Guys, Im creating a macro which highlights a cell based on its value, i have figured it out how to do it for tables, however, I was wondering if there is a way for me to select all the cells which contain percentages and loop through them and conditionally color them? I have this so far Dim...

Hello All, Thank you in advance for any and all your assistance. I am having difficulty figuring out how to highlight the surround cells of a cell containing text. I have a spreadsheet where an "X" is entered into various cells within a large range (ie. $C$3:$J$37). I would like to...

Hi, I am wanting to conditionally format columns if they have less than 6 of a certain entry. But have no idea how to start with this code. In this example below I need the conditional format to apply to column B when there are less than 6 YES entries. Column A also needs to be dependent on...

What formula is needed to Highlight only even numbers. </SPAN> the trick is I have the following formula</SPAN> =CONCATENATE('INDV Log'!AG41," ",'INDV Log'!AH41)</SPAN> the result is</SPAN> TEAM 2</SPAN> So there are 12 Teams and I just want to highlight the even teams with conditionally...