Forum Discussion

Brass Contributor

Nov 28, 2022

If Conditional is set record Yes in another cell

Hi I am trying to read if a conditional format is set and if so, record a Yes in another column. In this case I have conditional formatting set for column "F" which looks for OS Names that have ...

excel

Formulas and Functions

HansVogelaar

MVP

Nov 28, 2022

Frank145

In N2:

=IF(OR(ISNUMBER(FIND({"2000","2003","2008"},F2))),"Yes","")

Fill down.

Frank145
Brass Contributor
Nov 28, 2022
Thank you guys;

This worked fine.

=IF(OR(ISNUMBER(FIND({"2000","2003","2008"},F2))),"Yes","")