Forum Discussion
Conditional Formatting Cell Based on Its Corresponding Cell
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. ...
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.
I know I don't know anything (Socrates)