Forum Discussion

anantha9's avatar
anantha9
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's avatar
    SergeiBaklan
    Jun 23, 2023

    anantha9 

    With some assumptions about your data

Detlef_Lewin's avatar
Detlef_Lewin
Silver Contributor
Jun 22, 2023

anantha9 

Change your data into:

SubjectTargetActualActual %

And then use conditional formatting.

 

  • anantha9's avatar
    anantha9
    Copper Contributor
    Jun 22, 2023
    sir, how to do without changing data
    • SergeiBaklan's avatar
      SergeiBaklan
      Diamond Contributor
      Jun 23, 2023

      anantha9 

      With some assumptions about your data

      • anantha9's avatar
        anantha9
        Copper Contributor
        Jun 23, 2023

        SergeiBaklan, Sir ,if possible please share the video