Nov 28 2022 06:46 AM - edited Nov 28 2022 06:47 AM
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 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?
Nov 28 2022 06:58 AM
@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?
Nov 28 2022 06:59 AM
Nov 28 2022 07:05 AM