Format row based on cell value

Occasional Visitor

I am creating a classmate roster including both active and deceased members.  I want to create a conditional format for the entire sheet where all cells for a deceased member are in a different font color based on the text value in a cell.  

1 Reply



Based on the text value in a cell in column A you could apply above rule for conditional formatting.


This is the range in order to apply the format to the entire sheet.