Forum Discussion

Jessica0612's avatar
Jessica0612
Copper Contributor
Aug 14, 2023
Solved

Help with Conditional Formatting

I want to copy this conditional Formula Down Rows. However, when I attempt this, it does not update the formula, it keeps the original formula (Cell Ref AP4 and AE4).    I need the formula to updat...
excel
  • SergeiBaklan's avatar
    SergeiBaklan
    Aug 14, 2023

    Jessica0612 

    I guess that is

    =AND($AP4="Exempt", $AF4<80)

    applied to $AF$4:$AF$100 or so.

    No one will be highlighted based on screenshot.

Jessica0612's avatar
Jessica0612
Copper Contributor
Aug 16, 2023

SergeiBaklan 

 

Thanks! Changing the "Applies to" did the trick!

Resources