Hi.
I have an issue when trying to use conditional formatting to highlight row.
My sheet has row 1 as titles and questions and row 2 from C2:X100 is my area for pass & Fail answers. I want any row containing fail to be highlighted.
Ive been able to highlight each cell but not the entire row.
any help would be appreciated.
Thanks,
Damian
I have an issue when trying to use conditional formatting to highlight row.
My sheet has row 1 as titles and questions and row 2 from C2:X100 is my area for pass & Fail answers. I want any row containing fail to be highlighted.
Ive been able to highlight each cell but not the entire row.
any help would be appreciated.
Thanks,
Damian