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...
  • SergeiBaklan's avatar
    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.

Resources