conditional formatting question
Hi,
I preparing a French revision spreadsheet and trying to set up the
following, without much success.
In ColA I have English sentences. In Col B I have the correct French
translation of these sentences. (The sentences vary in length)
I want to hide Col B (I can do that!) and then I want to type in ColC
my version of the French translation of Col A.
Here's the part I can't do...
If I get it wrong (i.e. less than 75%), when comparing ColC to ColB, I
want to Excel to higlight the cell in red, if I get at least 75%-99%
of the sentence right I want Excel to highlight the cell in yellow and
if I get the translation 100% correct I want Excel to highlight the
cell in green.
I know it's got something to do with conditional formatting but I
cannot work out the logic to highlight cells based on percentage
correct...can someone help moi!
Thanks for reading and helping
Tony
|