S
swati
i want to know what is meant by reversed conditional formatting?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
B
bj
where did you see the term, and what was its context?
I do not know of any commonly accepted definitions
I do not know of any commonly accepted definitions
S
swati
i saw it in a worsheet i was working on with someone...it has been mentioned
that there are 2 rows which hve reversed CF and i will literally have to
check from around 100 formulae manually to check that one.
that there are 2 rows which hve reversed CF and i will literally have to
check from around 100 formulae manually to check that one.
B
bj
I would first assume that the conditions are giving the reverse formatting
that is wanted for example they might have wanted values above 10 to be green
and below to be red, but what is shown is above 10 is red and below as
green.
the answer may be just to change the conditional formats.
if the are common formats you may be able to select them all and change them
at one time.
that is wanted for example they might have wanted values above 10 to be green
and below to be red, but what is shown is above 10 is red and below as
green.
the answer may be just to change the conditional formats.
if the are common formats you may be able to select them all and change them
at one time.
S
swati
Thanks bj, i guess that will help!!
bj said:I would first assume that the conditions are giving the reverse formatting
that is wanted for example they might have wanted values above 10 to be green
and below to be red, but what is shown is above 10 is red and below as
green.
the answer may be just to change the conditional formats.
if the are common formats you may be able to select them all and change them
at one time.