conditiaonal formatting

I want to display the difference between forecasted time and actual time on a dashboard. I also want conditional formatting on these cells so that all positive values (later than expected) become redder as they increase, and all negative values (earlier than expected) become greener as they...

How to compare Workbook2 to Workbook 1, After match to show Statment "Yes","No" on workbook 1 We need to match Product / Description / HSN code /Qty / Rate/ Tex(%) from Workbook 2 , i can't know how to compare workbook and so if statment in Workbook 1 [ i Column ]

Hello, I have a sheet, within a file, I'm using to find skins, the lowest individual score on each golf hole, if there is one. I'm using conditional formatting and the formula: =AND(C4=MINIFS(C$4:C$36,C$4:C$36,">0"),COUNTIFS(C$4:C$36,C4)=1,-C$1) to highlight the cell if there is a skin on each...

Hi - I have an excel table with 6 Columns (fixed) and then I want to be able to fill in as much content in the rows without limitation. Problem: I want the table contents to fill into the charts and automatically and automate adjust, so that it’s easy to read with the same excel sheet if...

I am trying to build a spreadsheet that has multiple condition. When I plug in my conditions into conditional formatting, it won't work. 1st condition: I want 3 rows to be filled in blue, with border and vertical lines highlighted, one line no fill/border, then the next 3 rows to be no fill...

I am building a scheduling table with start and end times ... which then populate a "timeline" across the business day. The business day is a series of columns in 15 minute increments starting at 05:00:00 AM to 10:00:00 PM. The timeline fills the cells between the start and end times entered. I...

Afternoon, I need help with conditional formatting. If cell c10 is red i need J10, q10 and x10 to also turn red how do i go about doing this. Thanks Eve

Hi All, I'm trying (and failing) at getting excel to automatically insert a Note based on a specific cell value. i have my conditional formatting set up so that when a WBS code is inserted it changes to a specific pattern/colour, that is working fine. what i want it to do is to insert a note...

Hi, I'm trying to find a way to highlight a cell by using conditional formatting but need help. I'm trying to highlight cell V4 if there is a Y in cells D4:U4, can anyone explain how I go about achieving this? Many thanks Evie

Hello, I am trying to have excel create a tracking link based on which carrier an employee selects in Column G and the tracking # in Column H. Since each carrier tracking has similar link formatting, I would copy their link, but just need to change the tracking # part of it ... for example...

Hello, I'll start by saying I'm a little past novice with the power of Excel, but also not super intricately skilled—so hoping someone with more knowledge can assist! I am trying to have excel create a tracking link based on which carrier an employee selects in Column G and the tracking # in...

I created a calendar, I would like the days of the calendar to be formatted based on the profit or loss for that day. I figured I could have a query table that takes all the data from my main dataset and groups/sums the P&L by day, and then reference this table in a formula to format the...

Hello Ex(cel)perts, I hope you can help me with the following issue. We have large excel files with ascending numbers. B1aktenummer21324354657687981091110121113121413151416151716181619172018211922202321241252263274285296307318 If you can see is on row number 17 and 18 the same or double...

I've written the below which shades days on a calendar in grey, depending on whether the days fall within the "Start" and "End" range, however I would ideally like it to be different colours depending on who is in the "Assigned To" column e.g. light grey if it's "FACULTY", dark grey if it's...

Hello Forum, I have a workbook with alot of sheets. To easily check if any inspection is due i want my tab color to represent the most critical status to be shown. I tried piecing together some code but nothing really worked for me. In my column of inspection due dates i need to search for...

The attached XL2bb Mini Sheet shows in cell A1 the number 21 which is the next blank cell in B column. I would like to use conditional formatting to highlight the entire row based on the cell number that appears in A1 as a visual guide to open, in this case, Bogus 20 file, to get file content to...

Hello all, I was hoping to get assistance in the following matter. I am trying to track employees certification compliance. I need to conditional format dates based on different expiration time frame. for instance, employee A has a cert with the completion date of 14 May 19 but the cert has to...

I have one workbook. I have a data entry sheet where users can enter data (A3:H866) - vertical orientation. I also have a summary sheet (AB6:AM90) - horizontal orientation where I have used an Index formula to bring in values from the data entry sheets. The expectation is that if there is a...

i was try "Change Font Color Black to White After Found " 0" Value In E Column , And may be I hope Hide row According Zero value. ???" how to possible Conditional Formatting ????

I feel embarrassed to ask this question but I have searched for a solution and can’t find the solution. I have several dates in Column H. I want to format cells that have dates than are 365 days or older Red. I want similar formats for cells that are between 365 days and 180 days Orange I want...