EXCEL - Conditional Format based on another cell

I click on Conditional Formatting - New Rule - “Use a formula to determine which cells to format” … But then I cannot figure out what the correct formula is to type in the space.

I was thinking of an IF statement. =IF(1A=“GLOBAL”,?)… then I couldn’t figure out what to use in place of the question mark.

I tried doing it without that but it doesn’t work. I am either way off target, or just putting one small thing wrong each time I try, but I haven’t been able to get it where it works.


You don’t make an IF statement. Here’s what you’d put in the Formula


Click the Format button and select Fill to determine the color

Above is a snippet.

1 Like