conditional cell colour

Hi all, I have a pivot table, in which I have applied a conditional format. But it doesn't work. This screenshot will help in explaining what my problem is. https://photos.app.goo.gl/KL9QYLs2wtURwTtW2 As you can see, I have applied a conditional format to a certain field in my pivot table...

I have an Excel2007 spreadsheet into which data is entered daily (1 row each day). Various comps (min, max, avg, etc) are shown in each row. Cols into which data is (or will be) entered are shaded light green. Cells for computed data are shaded pink and protected. Some cells have conditional...

Hey guys, I'm working on a criticality-index of sort for work and can't quite seem to get it to format based on my desired conditions. So using the below graph for reference, I have different factors (columns A-D) scaled 1-8 based on criticality. Then I have a TOTAL column (E) which is just a...

Hi, I have to apply conditional formatting to a column in my spreadsheet. The last three columns in my spreadsheet are Course Status, Date Taken, Due Date. I need to apply conditional formatting to the Due date to show past due, coming due, and not yet due based on whether or not the course has...

Hi! I have what I think should be very simple, but is not working for me right now! I am working on a scorecard sheet. So, we have a number of metrics, and for each we have Target and Goal for every month. Then, for each metric, there is a calculation of the percentage-where are they in...

Hi, ROW 3 has dates from January 1st (C3) to December 31st (NC3). I want the todays date Cell change color, but all dates before maintain the same color, like a timeline add one cell everyday and maintain past dates with color and futures dates blank. -Is there a way to build this with formulas...

I wish to highlight the cell in column A if the text fragment "xxx" is present in any column from N through AF. I tried this but it only works when the text is in column N: =ISNUMBER(SEARCH("xxx",N2:AF2))=TRUE

Hello, I am trying to create a code that will highlight certain cells once a hyperlink has been clicked. I have multiple hyperlinks on the same sheet that, once clicked, link to certain cells on separate sheets. I would like to know if I can have a user click a hyperlink and have them be taken...

Hi, Hope I can find some insight here. I am working on highlighting cells in column Y and V $Y$2:$Y$35 / $V$2:$V$35 based on formula rule on $$AA2 values. Can anyone offer guidance on how to do this on VBA? Basically, if cells in AA2 do not = 0, are greater than or less than zero then I would...

I am creating a spreadsheet that shows where everyone is in my unit. I have created a drop down list that gives 24 options. Column D contains the list and Column E contains the notes. I have created the cf that when the "Available" selection is made, both column D and E in that row turns green...

Hi guys, I am fairly new to doing VBA coding stuff so if my question seems a bit obvious, that's why. I am trying to do a results table for football like this: <tbody> Team 1 Team 2 Team 3 Team 4 Team 1 2-1 0-3 2-2 Team 2 1-0 1-2 0-0 Team 3 4-1 2-0 2-0 Team 4 2-1...

Hi, First off I'm a true newbie regarding VBA etc. If I create a grid containing 28 columns and 19 rows, I would like to be able to enter the letter "A" in a cell somewhere in this grid and have excel colour green the cell where I entered the letter and then colour the rest of the column...