Get instant live Excel expert help with conditional formatting
“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 want to be able to alter the appearance (font color and fill) of a column of numbers using excel 2016 conditional formatting, based on being greater than or less than the numbers from another column. I am unable to get any formula to work. Please help!
Solved by I. J. in 26 mins
I need help on excel conditional color to change the color and text of a cell in row 2 based on a numerical value in row 1.
Solved by E. L. in 28 mins
Column A contains name of participants.
Column B contains the binary info of whether the participant won. If won, then 1, if lost, 0.
So, if I assign 1 to column B(meaning the participant won), I want the cell in column A&B to be highlighted in green.
Used Conditional formatting. But unable to assign this rule to all participants at once. Instead, I have to conditional format every participant.
Solved by X. H. in 17 mins
I have a volume cell & a price cell & i need a conditional formatting to highlight the price cell in red, if there is a value in the volume cell & no value in the price cell
Solved by D. D. in 16 mins
Hi. I am trying to apply a conditional formatting rule that I have for one column to a range of columns. Can you please assist?
Solved by A. J. in 22 mins
Hi, I need a way to use conditional formatting to make all the cells blank when the top shows "Game End"
Solved by T. F. in 30 mins
Formula help: =COUNTBLANK(offset(Inglewood!C$2,,MATCH(D3,Inglewood!$C$1:$N$1,0)-1,counta(Inglewood!$A:$A)-1))
This is helping me have conditional formatting based on empty cells from another tab. I want to change the range of data that is being seen. (i.e. instead of C2:C47 I want it to be C11:C47)
Solved by V. U. in 22 mins
I need to pout conditional formatting for a scenario where if the cell value is positive then green and red if the cell value is negative, however, i also need to give refernce to other cell where another value basis which i need to validate before giving the cell a red color
Solved by O. U. in 17 mins
I have a file in which I need to somehow use a conditional formatting for the same names of the data available, or if there is any other way to calculate the frequency of one particular name appearing.
Solved by K. F. in 17 mins
I need a formula in conditional formatting to shade cell O4 blue if cell F4 contains part of "District Active Support Member"
Solved by G. U. in 30 mins