Forum Discussion

Copper Contributor

Jun 22, 2023

Solved

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% ...

excel

SergeiBaklan
Jun 23, 2023
anantha9

With some assumptions about your data

anantha9

Copper Contributor

Jun 22, 2023

sir, how to do without changing data

SergeiBaklan

Diamond Contributor

Jun 23, 2023

anantha9

With some assumptions about your data

anantha9
Copper Contributor
Jun 23, 2023
SergeiBaklan, Sir ,if possible please share the video
- SergeiBaklan
  Diamond Contributor
  Jun 24, 2023
  anantha9
  
  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.75
  
  instaed of B5 use relative reference on top left cell of your range.