Get instant live Excel expert help to learn how to use conditional formatting 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 have a list of data with 6 digits followed by a dash and two letters (123456-AA) I want a conditional formatting that will color the cell if the first 6 digits match. I know how to use Left(cell #,6) to separate the digits. I also know how to format a regular full match. I just don't know how to combine them.
Solved by S. E. in 30 mins
I want to be able to use conditional formatting to highlight a column of different values in comparison to another column, but all the values vary. I know how to use conditional formatting to highlight a value over or under a set amount but not a varied one?
Solved by E. E. in 18 mins
I have a list of price and I would like to fill a color for the corresponding amount
$100 - $199 - Green
$200 - $299 - yellow
$300 - $399 - orange
$400 - $499 - red
$500 - gray
is there's a way it was automatically fill if the amount was entered? I believe it was conditional formatting but I don't know how to use it.
Solved by F. H. in 19 mins
Can you help me how to use the conditional formatting?
Solved by B. H. in 24 mins
How to Use Conditional Formatting to Change Cell Background Color Based on Cell Value not for only 1 cell but all the cells depending upon the cell value entered. for example I have four status as 1 )open 2) Resolved 3) Overdue 4) hold. I want the cell should change color as green if resolved and red as overdue and open as brown and hold as yellow.
Solved by V. Y. in 25 mins