Conditional Formatting Excel Based On Another Cell. In this video we ll look at how to apply conditional formatting to one cell based on values in another using a formula. Select the entire data.
How to use conditional formatting based on another cell value. In this window mention the text value that. That is we would be formatting a cell based on the value within that cell.
That is we would be formatting a cell based on the value within that cell.
It would be simple because the cells we are formatting are the same cells that have the values to evaluate. Criteria 1 text criteria. Let s say you want to highlight the names of. C5 j 6.
