Get instant live Excel expert help with conditional formatting

Making a dynamic gantt chart using conditional formatting, IF statements, WEEKDAY function, drop down menus, etc.

I need help on conditional formatting with dates. Should be super easy.

Hello Can you please tell me how to set a date column to show a different colour in the cell when an expiry date is due within a month or less. I've tried conditional formatting but so far hasn't given me what I'm after. For example 26/10/2016 should show as a red cell to say that it's just about to expire. Thank you in advance

Create a new conditional formatting rule that uses a formula to determine which cells to format in the range A4:A57. Apply bold font style and blue font color (eighth column under Standard Colors) to film titles with a rating of PG-13 and a profit of more than $125.

Hello team i have an issue with the conditional formatting, i know it would be simple for you but the problem is i am unable to apply conditional formula to color a cell on acquiring a date that is equal to todays date. The value in the cell is acquired using =X2+28 simple add. Cant i apply a conditional formula on this simple math value using cell ?

I am truly a beginner in Excel and need all the help I can get! Okay so I have a table that is $A$2:$N$333 and I would like column A to show a data bar to reflect the data that each row has completed. Example: Row 3 has data in every column up to G now I'd like Cell A3 to show a 50% data bar in that cell to show that only 50% of the data needed for that row has been entered. Is that possible and how would I go about doing so? (this is the reply I revieved from tech support) If you add another column for the data bar, you can do it with conditional formatting. If you insert a column before column A and inserted this formula: =COUNTA(B5:O5)/14 And then use conditional formatting in the cells in column A (open) conditional formatting Use: format all cells based on their values Choose data bar from drop down check box to show data bar only (in type) choose number from drop down Enter 0 on minimum and 1 on max Use solid fill and no border and hit okay I COULDN'T COPY AND PASTE THE IMAGE SO I DESCRIBED IT AS BEST AS POSSIBLE (This is my reply ) So after I've entered the formula into each cell down column A do I high light all of column A and then select the conditional formatting with Data bar? So I did Just that I copied the formula into each cell in column a and then I highlighted the column and did the conditional formatting using Data bars and I got nothing. In the picture it says edit formatting rule. I made a new rule with all of column A highlighted was I supposed to go through the manage rules window instead of make a new and also in the picture it says minimum (Type) Number 0 and max Number 1 was I supposed to put that in as well? Thanks for all your help I'm sorry I am so new at this excel stuff AND THEN I RECEIVED THIS REPLY Yes, you need to have it look exactly like the image I posted for it to work, so you'll need the types to be numbers and values to be 0 and 1. OKAY SO THIS ONLY ANSWERED ONE OF MY QUESTIONS AND IT STILL ISN'T WORKING CAN YOU HELP ME? PLEASE THANKS FOR ALL YOUR HELP VINTA

Given the stock data, I still need to: - find portfolio with minimum risk - use conditional formatting to find the stock of least variance - pick stocks that will generate a return of .3% Thank you for your help!

5. Using conditional formatting, identify the stock with least variance. Also using conditional formatting, identify the column corresponding to the stock with least variance, which are the 3 stocks whose returns have least covariance within said stocks? These 3 stocks, do they belong to the portfolio of least variance? Why or why not? 6. If someone wanted to have a return of .3%, what stocks would they need to buy and in what proportions? Know that proportions vary between [0, 1] and that the summation of the proportions is equal to 1.

Hi I have a cell in excel that i would like to use conditional formatting on. this cell would then look at 2 or more other cells in the same column to see if the value has been duplicated and then change the cell color background to orange or red if the same value is found. thankyou

I am trying to add a conditional formatting to an excel sheet based on percentages