condition format

Hi. I have a spreadsheet for some assessment results (See my other posts). the cells are condition formatted so that they turn red when the assessment has failed. I am trying to get a formula to count the cells that have turned red, for each individual trainee, however the normal count functions...

Hello, I'm having some trouble getting a Conditional Formatting Rule to work using the INDIRECT function. I'm using a formula within the Table for testing in column 'C'. Column 'E' - outside the Table - was converted to use the INDIRECT function to work from outside the Table. Columns A:B...

Hello, I am trying to Highlight multiple cells based on a specific cell. If cell K32 = True, I want cells B2:G239 highlighted in one color and if K32 = False, then no change. I have tried the following with no luck: Thanks in advance for any assistance!

# How to Find particular text in Date ?????? i try to find "2021" in this cell , If Condition is " OK" and if then may be change text like "2020" this condition show "Mistake"

I want BOLD RED font for the entire row if the date in ColA is greater than today's date, else "no bold & black". How do I do that?

Hello everybody I am here because I am trying to write a very easy code. The idea is that if in Column A it says TBR and at the same time in Column E it says No, the E cell where it says No turns into Yellow. I wrote this code but it does not work. Please please help me :) Thank you so much...

Hi folks, Trying to use a traffic light conditional format on some figures in my spreadsheet but just cannot get it to work. As you can see below, the 84.21% value for example should be green but is showing as amber. The 72.72% value should be amber but is red. Does anyone have a clue what...

Hi Newbie here I have a range name which I would like to format using conditional formatting. When I change the cells that the range name refers to I want the it to format the new range. This might not be the easiest way to do it so I'm open to alternative suggestions. Essentially what I...

I have a column created where user enters resource names. There is another column after previous column where user inputs color associated with that resource. I have a cell range defined which contains resource names from this list and I need to condition format this range for colors specified...

So i did a HLOOKUP in comparing two table columns. The Hlookup came back with errors for data that didnt match the table column names. Is there a way for me to highlight the cells in C2 if Cell A2 has #N/A in it?