Conditional Formatting Cell Based on Its Corresponding Cell

[renjie0315]

Hi all!

I would like to know how to do conditional formatting based on on its individual corresponding cell?

For example, the rule of cell B3 should follow the condition of C3 and so on.

[#2]

@renjie0315 

Use conditional formatting to highlight information

First select the cell or range you want to format. 

In your case Cell B

Path Home -> Conditional Formatting -> New Rule -> Use formula to determine formatting cells.

Format values for which this formula is true:

=$C$3="No"    Format or fill in the cell according to the color you want.

=$C$3="Status"  Format or fill in the cell according to the color you want.

See simple example in file

Hope I could help you with these information / links.

NikolinoDE

I know I don't know anything (Socrates)