Forum Discussion
Jesling
Jan 26, 2022Copper Contributor
Highlight FIRST EVER row ONLY
Hey guys, I have a file with column stating "Financial Free" or "Keep on Going". By usual conditional formatting, I able to highlight all the rows with "Financial Free" in green. However, I only want...
Lorenzo
Jan 26, 2022Silver Contributor
Hi Jesling
Alternatively and using @DTE range (C4:C16):
- Select C4:C16
- Home > Cond. Format. > New rule > Use a formula...
=COUNTIF(C$4:C4,"Financial Free")=1
Jesling
Jan 27, 2022Copper Contributor
Hi Lorenzo, I have tried yours too. But it seems like not working still. Nothing was highlighted, I am not sure what's wrong. Is it because the column itself is with formula, not purely text. So, the conditional formatting is not working?
Anyways, thank you so much for replying me. Hope to hear from you soon.
Anyways, thank you so much for replying me. Hope to hear from you soon.