conditional format

Hi All, Really need your help as I am pulling my hair out on how to do this! Basically I have a column (F) which is has a date in for 'Date Response Required By' , and column (I) has 'Impact against programme'. Column 'I' has the formula input into the cells to work out the programme...

Afternoon everyone... I am having a right mare with my conditional formatting formula and i feel like I've tried every variation and I've given up now... I have a list of master codes in one sheet "EWC List" I then input incoming loads in another sheet "Stock" if while i'm inputting the EWC...

I have a sheet where I need to highlight cells in column Y based on a word being present in column G and the value of Y being greater than 0.2 I tried using =AND(G2:G1048576="Draw",Y2:Y1048576>0.2) but it generates an error What is the correct syntax for what I want? It is basically column G...

Good afternoon, I am trying to determine how to conditionally format a column of cells that will already show red when overdue. However, I want it to turn green once data is inputted to column G. I have attached the document for ease of use. So say E3 shows red because they have been enrolled...

I'm struggling to find the write formula to write in Conditional Formatting to highlight ONLy the last cell in each column that has a value but only on the condition that a value above is met. So in my case if the value in Row 6 = "YES" then highlight the last cell in that column that has a...

I have noticed when using the conditional format screen, if I have scrolled left or right in the worksheet prior to opening the conditional format screen, my cursor click within a formula will not place the caret/ typing location where my cursor clicked. I seem to have to close the workbook and...

I have a sheet that is used as a template within a workbook, i.e. any new sheets that rely of the layout get created from the template sheet and the formula/conditional formatting get updated by the code. Once the sheets are created (there may be multiple), the user can specify which previous...

Hello, I'm currently using the following CF Rule to highlight cells in two columns that meet a single criteria from a list on another sheet. =SUM(COUNTIF(C2,"*"&INDIRECT("t_Whitelist[Author-Series]")&"*")) However, I would like to expand my criteria to only highlight the cells that meet the...

Hi, I am trying to apply an formula to highlight prices in Columns G, L and Q that are outside +/- a stated percentage of the average value for that price: Column G Column L Column Q Column T Row 1 10% Row 2 A B C Median/Average Row 3 - Nuts 31 42 32 35 Row 4 - Bolts 11 9 7...

Hello, I would be really grateful if someone could answer the following If the TOTAL of two cells is less then the value you of another cell then post cells red, for example; if A3+A4 is less than C5 turn cells red thank you in advance

Hello, I am trying to make a floor plan and wanted the booth squares to turn red, if they are matched with the same booth number located in B2:B22.

I am using the Sub Mail_Selection_Range_Outlook_Body() from Ron de Bruin to set up a macro to send an email taking the information from several sheets with reports that I have to send and it works pretty well, but the code doesn't allow conditional formatting to be pasted into outlook. The...

Hi everyone, I’m new to this forum / VBA and I’m trying to create a code that applies conditional formatting for all columns in every pivot table and refreshes every table in my Excel workbook. I’ve been able to set this up for one pivot table / one sheet but I’m not sure how to change my code...

Hello all, I have a table (Query 1) which pulls data from an SQL server and auto refreshed every 2 minutes. This table has rows each depicting a single order with columns showing various information about the order (Value, Status, Allocation etc) In this table i have a column called "Last...

Is it possible to format cells which contain specific text, for more than 1 instance. Tried this with formula but no good. =ISNUMBER(OR(SEARCH("test1",A1),SEARCH("test2",A1)))

Hi I want to highlight multiple cells of text and numerical values with conditional formatting This is the prompt, PROMPT: "Highlight only cells that contain numerical value >0" Logically it will be solved with the "greater than" option then, cell value >0 However the cells sometimes have...

Hi Gurus, Could you help me simplify below code which I recorded? Basically, I need to apply these conditional formatting and hoping that the macro will look for Change 1, Change 2 and Change 3 header name and reflect the number format for all tabs (as the column might interchange on the other...

i have a sheet with values in Column D and E Now, they enter values in E45 and E36 Afterwards, they enter a value on D48 (They should calulate the difference of E45 and E36 The conditional formula should make the cell D56 red if they value they enter is not equal to the difference of E45 and...

Hi there, I have 5 conditional formats that I need to combine into one. Conditional format 1 =AND(M$9>=$J19,M$9<$J19+ROUNDDOWN($D19*($K19-$J19+1),0)) Conditional format 2 =AND(M$10>=$J19,M$10<$J19+ROUNDDOWN($D19*($K19-$J19+1),0)) Conditional format 3...

So I have a macro that I released to my coworker to use, however, the conditional formatting won't highlight for her. If I run the macro on my computer, the highlighting works. The conditional formatting is only on one sheet and the formula does not reference another sheet. I don't know if...