How to format data based on other cell conditions in Excel

Conditional formatting in Excel makes it easier to categorize or highlight data, based on the conditions you set.

However, there are also cases where you will format the condition based on the data of another cell. Basically, the conditional formatting operation based on another cell is the same as when you create conditional formatting. Below are detailed instructions for other cell-based conditional formatting on Zalo.

Guide to Conditional Formatting Based on Other Columns Excel

Step 1:

First we create a data table on Excel as usual. Now you highlight the data column you want to create conditional formatting based on another column. Then click on Conditional Formatting and select New Rule .

How to format data based on other cell conditions in Excel Picture 1How to format data based on other cell conditions in Excel Picture 1

Step 2:

Now display the interface to set the format. At the list of format types, scroll down and click Use a formula to determine which cells to format .

How to format data based on other cell conditions in Excel Picture 2How to format data based on other cell conditions in Excel Picture 2

 

Next at Format values ​​where this formula is true , enter the format condition as =C33 >= $D33 . Where C33 is the starting cell of the column to be formatted, D33 is the column of conditional data provided that column C33 is greater than or equal to the data in column D33.

How to format data based on other cell conditions in Excel Picture 3How to format data based on other cell conditions in Excel Picture 3

Step 3:

You click on the Format button and then click on the Fill tab to choose the color you want to set for the data formatted according to the condition. After setting up, click the OK button to save the format for the data according to the conditions you choose.

How to format data based on other cell conditions in Excel Picture 4How to format data based on other cell conditions in Excel Picture 4

Step 4:

As a result, you will see the data cells are formatted based on the conditions you set. Cells with higher values ​​are marked for easy identification.

 

How to format data based on other cell conditions in Excel Picture 5How to format data based on other cell conditions in Excel Picture 5

How to format Excel data based on another cell

Step 1:

First you also create the data table and the value cell you want to use as a condition. Next, highlight the column you want to format the data, then click on Conditional Formatting and select New Rule .

How to format data based on other cell conditions in Excel Picture 6How to format data based on other cell conditions in Excel Picture 6

Switch to the new interface, click Use a formula to determine which cells to format .

Next, enter the condition =$C33 > $F$34 with cell F34 as the conditional data for you to format for column C33.

How to format data based on other cell conditions in Excel Picture 7How to format data based on other cell conditions in Excel Picture 7

Step 2:

Click the Format button and then click the Fill tab to choose a color for the data. Finally, click OK to proceed with formatting the data according to the value condition in the selected cell.

How to format data based on other cell conditions in Excel Picture 8How to format data based on other cell conditions in Excel Picture 8

 

As a result, we will see data cells that are greater than or equal to the condition value cell you have selected.

How to format data based on other cell conditions in Excel Picture 9How to format data based on other cell conditions in Excel Picture 9

5 ★ | 1 Vote