EXCEL - Conditional Format based on another cell

QUESTION
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.

REPLIES

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

=A1="GLOBAL"

Click the Format button and select Fill to determine the color

SOURCE
https://www.eng-tips.com/viewthread.cfm?qid=379622
Above is a snippet.

1 Like