How to Create a New Conditional Format Rule in Excel - Tutorial

Excel tutorial on how to make a new Conditional Format rule in Excel. This Conditional Formatting rule will be based on the value of another cell.

Excel already contains a number of preset Conditional Formats that can be applied at the click of a button and, for most everyday uses, they’re perfect.

The trouble is that they only apply to the value of the cell selected. This is not too helpful when you need to format a cell based on another cell’s value. This is a situation in which you may want to create your own Conditional Formatting rule.

*FYI:

Thanks for watching this Microsoft Excel tutorial and, don’t forget, if you like this video, please “Like” and “Share” with your friends – it really helps us out 😊

Thanks!

*DISCLAIMER: This video description contains affiliate links, which means that if you click on one of the product links, I’ll receive a small commission. As an Amazon Associate I earn from qualifying purchases. This helps support the channel and allows us to continue to make tutorials like this. Thank you for your support!

#YAcostaTutorials

[pccomputer]

Great explanation, my question is how to make a rule so that the formatting of a cell let's say G4 is determined and changed based on 2 possible word (apple or Orange) in another cell B4 (same row), and that would be the rule for the entire colomn G and B ?for example if B4 is orange then change the color of G4 to red and if it's B4 is apple then change G4 to green, Much appreciated if you give the answer .