Get instant live expert help on I need help with format painter in excel
“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”
Here are some problems that our users have asked and received explanations on
I need help with conditional formatting in excel 2016 to adjust to each row the cell is on. I used the format painter but this copies the same formula to all cells. need it to adjust to every row.
Solved by D. Q. in 17 mins
I TRIED TO COPY THE FORMAT FROM ONE CELL TO ANOTHER AND IT WON'T CHANGE. WHEN THE TOTAL AMOUNT IS ZERO, THE CELL SHOWS A DASH - I WANT TO SHOW A DASH IN ANOTHER CELL WHERE THE TOTAL IS ZERO SO USED THE FORMAT PAINTER AND IT DIDN'T WORK. IT SHOWS (O.OO). WHAT DO I DO TO CHANGE IT TO A DASH?
Solved by C. J. in 24 mins
I could use some major help on a few spreadsheets that require Vlookup, format Painter and formulas. The object of the sheet is to track books that a company (i.e. Nordstrom) has purchased for the entire year. The spreadsheet was started by my predecessor who is much more of an Excel whizz. Help!
Solved by D. F. in 23 mins
Conditional formatting across a column
Y6>=$C$2 Format J6
I've tried relative and absolute referencing to the cells and used format painter to copy down column J but it all formats when it shouldn't, same when using colum referencing rther than cell.
So checking if a date cell is greater than or equal to a date in cell C2 and if it is to change the format of cell in column J. Should I be doing this a different way?
Solved by F. Q. in 16 mins
hi I have a spreadsheet that uses conditional formatting. ive created a new formatting rule -> use a formula to determine which cells to format.
My formula is =if(bg7 = true, true, false)
it works but I want to copy and paste it to rows below. ive used the format painter button but it doesn't automatically change the cell from bg7 to bg8 to bg9 etc. seems like I have to do manually
Solved by E. J. in 21 mins