How do you create IF function with YES/NO, and Color fill

[Brandon]

How do you create an IF function to color fill a cell with, for example,
green if YES is entered, or red if NO is entered?? For example: IF(I3:I120,
"YES" THEN COLOR=0,176,80) and IF(I3:I120, "NO" THEN COLOR=255,0,0).

thanks,
Brandon

 

[Bob Phillips]

Use conditional formatting.

See http://www.contextures.com/xlCondFormat01.html

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)

 

[Dave]

Hi,
Excel has no built-in "Color" function, (that I know of). You could write
one, but Conditional Formatting is easier.
Dave.