“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”

Hi I was trying to see if it was possible to transpose data in between conditional formatting. Basically if there is data in between a coditional formatting cell it would transpose the data (from a column to a row) and once it hits the next conditional formatting cells in excel it would move to the next row.
Example A1(Conditional Formatting Cell)
A2
A3
A4
A5(Conditional Frormatting Cell)
to:
A1 A2 A3 A4
A5 etc etc

Solved by G. J. in 16 mins

How do I create a formula for conditional formatting that will highlight the entire row if the value in A is a number and the value in B is an error.

Solved by G. U. in 22 mins

I would like to use conditional formatting to be able to make the colour of row change according to the date in that row in one of the columns. So that the rows are one colour if the date is up two one week old then another colour for 1 to 2 weeks old, then another colour for over 2 weeks old.

Solved by E. E. in 29 mins

I've used conditional formatting to highlight the lowest and highest numbers in a row. The problem is I want to use the same format to highlight the highest and lowest numbers in the next 1000 rows in exactly the same way. Each time I try to use format painter it doesn't work and if I try and highlight all the cells then it will only highlight the highest and lowest number from all the highlighted cells regardless of what row they are in. To make matters more complicated the columns I want excel to take the information from aren't adjacent to one another. Can you help please?

Solved by K. B. in 13 mins

Good morning. I'm just trying to work out if it is possible with Conditional Formatting to make it so that a cell would be filled in with a colour when the number value becomes 8500 more than the value of another cell. I've been able to do it if the cells are in a row using the =SUM function but if the two cells are in different locations on the spreadsheet (e.g A2 and E16) it doesn't want to do it. Is there a way I can do this?

Solved by B. H. in 20 mins

Hi there need some help with conditional formatting please, using =AND(LEFT(K$4,4)="1350",K9>K34,K5<>"Buy") trying to make the cell not highlight red if buy is in row 5 but not working

Solved by O. B. in 20 mins

Could someone help with a conditional formatting formula please.
I have a worksheet where i would like a row to be highlighted depending on a couple of conditions.
The sheet is K to Y in M is the leave date of the staff member then in Q there is a drop down list containing 3 options Deleted, Proxy for 1 month and Proxy for 3 months
If the option Proxy for 1 month is selected then i would like the row highlighted when the date in M is one month old
If the option Proxy for 3 months is selected the i would like the row highlighted when the date in M is three months old. If deleted is selected then do nothing.
Just cannot get the date thing!

Solved by K. J. in 24 mins

Hi there looking some help on conditional formatting. the formula I am using is =AND(LEFT(K$4,4)="1350",K9>K34,K5="sell") and it applies to =$K$9:$Z$22. But for some reason it is only working for the row 9 and no others. Could you please assist? I unfortunately cant share the file because it has company information

Solved by A. W. in 18 mins

Making a dynamic gantt chart using conditional formatting, IF statements, WEEKDAY function, drop down menus, etc.
1. COMBINE THESE FORMULA INTO A SINGLE NESTED IF STATEMENT. SO FAR I HAVE RUN INTO CIRCULAR CELL REFERENCE ISSUES SO I AM NOT SURE IT THIS IS POSSIBLE OR IF WE NEED TO FIND ANOTHER WAY.
If (Start Date=Row Date, when true, fill in a value of 1, if false, no value.
IF(E10=K9:DI9, 1,””)
Search the row and insert a 1 on the correct starting date.
This formula is correct.
If(sum of K10:DI10<D10,1,””)
Insert a 1 value until the total number of days is reached. This formula allows us to add in travel days for clients quickly by replacing a 1 value with an x. The formula automatically inserts a 1 value at the end of the plan for each “x” input. Does not count values of “” or x.
This formula is correct.
If Delivery Date=5, insert an “x” for WEEKDAY value of 7 and 1 (Do not make food on Friday and Saturday)
If Delivery Date=6, insert an “x” for WEEKDAY value of 7 (Do not make food on Friday)
If Delivery Date=7, no action required (Deliver meals 7 days per week)
This formula needs to be written.
Conditional formatting for table:
1 value = green font, green background, complete
x value = grey font, grey background,
This conditional formatting is set.
2. DYNAMIC END DATE
Use a formula to look up the last value of 1 in the row K10:DI10 and return the date from K9:DI9. This value will be shown in cell F10
In cell F10, =find the final 1 value in row K10:DI10 and return value from K9:DI9. This allows us to automatically update the end of plan to inform clients when their renewal is due.
This formula needs to be written.
3. SET THE PROJECT START AND END DATE IN CELLS C5 AND C6 TO AUTO FILL THE CALENDAR DATES.

Solved by S. Q. in 23 mins

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

Solved by E. Q. in 26 mins