If Conditional is set record Yes in another cell



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 2000, 2003, or 2008 in the cell. 


What I am trying to do is read the conditional format of "F", and if the cell is "Red" add a 'Yes" to the corresponding cell in column "N". Or will a nested IF work better to read if the cell contains 2000, 2003, or 2008? 






3 Replies

@Frank145 Probably easiest to use the underlying formula for the CF rule(s) and use that in column N. Can you show the CF rules that set the colors in column F?


In N2:




Fill down.

Thank you guys;

This worked fine.