How to Format a cell with reference to another in Excel

New to Excel? Looking for a tip? How about a tip so mind-blowingly useful as to qualify as a magic trick? You're in luck. In this Excel tutorial from ExcelIsFun, the 270th installment in their series of digital spreadsheet magic tricks, you'll learn how to

create conditional formatting for a cell based on the value of second cell. This particular tutorial uses a logical TRUE/FALSE formula to turn the conditional formatting on and off.