Conditional format to set "yes" if highlighted in Column

I would recommend that you use formulas instead. I don't favor having cells that look like they have data then they really don't.

If you really want to do this with CF you would use the following custom number format:
"YES"@
in red font.

In either case you will have to use the same rule you used to set up the conditional formatting for column F. There is no built-in function that can tell you if a cell is red.

What is the rule you are using for F to determine if the date is overdue?

Originally Posted by Gregb11

IN your Conditional Formatting, when you reference column F, use the Absolute version $F. And in the "Applied to" section, add the H Column range

So your Applied to probably looks like this:

$F$4:$F$3000

change it to:

$F$4:$F$3000,$H$4:$H$3000

This would apply the same formatting in column H as is set up for column F, but OP wants different formatting in column H. The second rule being requested can just use $H$4:$H3000.

For example, if the first rule is:

Formula:

Please Login or Register  to view this content.

Red fill
Applies to $F$4:$F$3000

then the second rule can be

Formula:

Please Login or Register  to view this content.

Format "YES"@
Applies to $H$4:$H$3000

In this particular case, absolute addressing is not required.