Forum Discussion
anantha9
Jun 22, 2023Copper Contributor
excel
i will share i excel sheet , in that i need >75% to be highlighted. kindly help me OE1: Open Elective Language L1- KANNADA Physical Education MENTORING GENERAL ENGLISH 25 - 15 - 60% ...
- Jun 23, 2023
anantha9
Jun 22, 2023Copper Contributor
sir, how to do without changing data
SergeiBaklan
Jun 23, 2023Diamond Contributor
- anantha9Jun 23, 2023Copper Contributor
SergeiBaklan, Sir ,if possible please share the video
- SergeiBaklanJun 24, 2023Diamond Contributor
1) Select the range with data without headers, here B5:F16
2) on ribbon Home->Conditional Formatting->Manage rules->New rule->Use a formula to determine...
and
In formula
=IFERROR(--RIGHT(B5,4), 0) > 0.75instaed of B5 use relative reference on top left cell of your range.